How to fetch the candidate name from the candidacy.

Hi all,

Can any one please tell me in which database table that the candidate name will be stored and how to fetch it from candidacy.

Any help regading this is highly helpful.

Thanks and regards,

Bharathi.