Wrote BI publisher SQL query to list the types of letters , but cannot link it to candidates?
select distinct idl.Name
from irc_descriptions_b idb,
irc_descriptions_tl idl ,
IRC_DESC_VERSIONS_B idv,
irc_requisitions_b irb
where
description_type_code='ORA_JA_EMAIL_TEMPLATE'
which table to link it to get the candidates data?
Tagged:
1