APPS.PER_IREC_ICD_ENRLL_PROCESS dependencies on HR_ORGANIZATION_INFORMATION

Line 147: FROM HR_ORGANIZATION_UNITS haou, HR_ORGANIZATION_INFORMATION haoi

143: --
144: l_dummy varchar2(240);
145: cursor c_bg_name is
146: SELECT haou.NAME
147: FROM HR_ORGANIZATION_UNITS haou, HR_ORGANIZATION_INFORMATION haoi
148: WHERE
149: haou.organization_id = haoi.organization_id AND
150: haoi.org_information_context = 'CLASS' AND
151: haoi.org_information1 = 'HR_BG' AND

Line 153: not exists (select 1 from HR_ORGANIZATION_INFORMATION haoi2

149: haou.organization_id = haoi.organization_id AND
150: haoi.org_information_context = 'CLASS' AND
151: haoi.org_information1 = 'HR_BG' AND
152: haoi.org_information2 = 'Y' AND
153: not exists (select 1 from HR_ORGANIZATION_INFORMATION haoi2
154: where haou.organization_id=haoi2.organization_id
155: and haoi2.org_information_context='BG Recruitment'
156: and haoi2.org_information9='Y') AND
157: BUSINESS_GROUP_ID=p_bg_id;