DBA Data[Home] [Help]

APPS.IRC_SEEKER_VAC_MATCHING_PKG dependencies on PER_RECRUITMENT_ACTIVITIES

Line 706: per_recruitment_activities pra ,

702: FROM DUAL
703: WHERE EXISTS ( SELECT 1
704: FROM per_all_vacancies vac ,
705: per_recruitment_activity_for praf ,
706: per_recruitment_activities pra ,
707: irc_all_recruiting_sites site
708: WHERE
709: vac.vacancy_id = praf.vacancy_id
710: AND praf.recruitment_activity_id = pra.recruitment_activity_id

Line 741: per_recruitment_activities pra ,

737: FROM DUAL
738: WHERE EXISTS ( SELECT 1
739: FROM per_all_vacancies vac ,
740: per_recruitment_activity_for praf ,
741: per_recruitment_activities pra ,
742: irc_all_recruiting_sites site
743: WHERE
744: vac.vacancy_id = praf.vacancy_id
745: AND praf.recruitment_activity_id = pra.recruitment_activity_id

Line 906: , per_recruitment_activities pra

902: FROM irc_search_criteria icrit_vac
903: , irc_posting_contents ipc
904: , irc_posting_contents_tl ipc_tl
905: , per_recruitment_activity_for praf
906: , per_recruitment_activities pra
907: , irc_all_recruiting_sites site
908: , per_all_vacancies vac
909: , hr_locations_all loc
910: WHERE icrit_vac.object_type = ''VACANCY''