APPS.PER_IREC_ICD_ENRLL_PROCESS dependencies on HR_ORGANIZATION_INFORMATION

Line 191: FROM HR_ORGANIZATION_UNITS haou, HR_ORGANIZATION_INFORMATION haoi

187: --
188: l_dummy varchar2(240);
189: cursor c_bg_name is
190: SELECT haou.NAME
191: FROM HR_ORGANIZATION_UNITS haou, HR_ORGANIZATION_INFORMATION haoi
192: WHERE
193: haou.organization_id = haoi.organization_id AND
194: haoi.org_information_context = 'CLASS' AND
195: haoi.org_information1 = 'HR_BG' AND

Line 197: not exists (select 1 from HR_ORGANIZATION_INFORMATION haoi2

193: haou.organization_id = haoi.organization_id AND
194: haoi.org_information_context = 'CLASS' AND
195: haoi.org_information1 = 'HR_BG' AND
196: haoi.org_information2 = 'Y' AND
197: not exists (select 1 from HR_ORGANIZATION_INFORMATION haoi2
198: where haou.organization_id=haoi2.organization_id
199: and haoi2.org_information_context='BG Recruitment'
200: and haoi2.org_information9='Y') AND
201: BUSINESS_GROUP_ID=p_bg_id;