[Home] [Help]
APPS.HRI_OPL_RECRUITMENT dependencies on IRC_VACANCY_CONSIDERATIONS
Line 317: irc_vacancy_considerations ivc
313:
314: CURSOR pursued_apl_csr IS
315: SELECT 1
316: FROM
317: irc_vacancy_considerations ivc
318: ,per_all_people_f peo
319: WHERE ivc.party_id = peo.party_id
320: AND peo.person_id = p_person_id
321: AND p_effective_date