DBA Data[Home] [Help]

APPS.IRC_APL_PROFILE_ACCESS_API dependencies on HR_ORGANIZATION_INFORMATION

Line 28: (select bginfo.organization_id from hr_organization_information bginfo

24: and trunc(sysdate) between asg.effective_start_date and asg.effective_end_date
25: and trunc(sysdate) between per.effective_start_date and per.effective_end_date
26: and trunc(sysdate) between allper.effective_start_date and allper.effective_end_date
27: and asg.business_group_id in
28: (select bginfo.organization_id from hr_organization_information bginfo
29: where bginfo.ORG_INFORMATION_CONTEXT = 'BG Recruitment'
30: and bginfo.org_information11 = 'Y')
31: and per.person_id = irc_utilities_pkg.get_recruitment_person_id(p_person_id);
32: --