APPS.PAY_NL_IZA_UPLOAD dependencies on HR_ORGANIZATION_INFORMATION

Line 109: from HR_ORGANIZATION_INFORMATION

105:
106:
107: cursor csr_iza_info(v_org_id number) IS
108: select ORG_INFORMATION1,ORG_INFORMATION2,ORG_INFORMATION3
109: from HR_ORGANIZATION_INFORMATION
110: where ORG_INFORMATION_CONTEXT='NL_IZA_REPO_INFO'
111: and organization_id = v_org_id;
112:
113:

Line 116: from HR_ORGANIZATION_INFORMATION hoi, HR_ORGANIZATION_UNITS hou

112:
113:
114: cursor csr_organization_id(v_client_number varchar2,v_sub_emplr_number varchar2,v_bg_id number) IS
115: select hoi.organization_id
116: from HR_ORGANIZATION_INFORMATION hoi, HR_ORGANIZATION_UNITS hou
117: where ORG_INFORMATION_CONTEXT='NL_IZA_REPO_INFO'
118: and lpad(ORG_INFORMATION1,3,'0') = v_client_number
119: and lpad(ORG_INFORMATION2,3,'0') = v_sub_emplr_number
120: and hou.ORGANIZATION_ID = hoi.organization_id

Line 190: SELECT iza_org_id from hr_organization_information e,(

186:
187: UNION
188:
189: (
190: SELECT iza_org_id from hr_organization_information e,(
191: SELECT distinct pose.organization_id_child iza_org_id
192: FROM per_org_structure_elements pose
193: where pose.org_structure_version_id = v_org_struct_version_id
194: START WITH pose.organization_id_parent in (select distinct piza.organization_id

Line 204: SELECT iza_org_id from hr_organization_information e1,(

200: CONNECT BY PRIOR pose.organization_id_child = pose.organization_id_parent)
201:
202: MINUS
203:
204: SELECT iza_org_id from hr_organization_information e1,(
205: SELECT distinct pose.organization_id_child iza_org_id
206: FROM per_org_structure_elements pose
207: where pose.org_structure_version_id = v_org_struct_version_id
208: START WITH pose.organization_id_parent in (select distinct piza.organization_id

Line 250: FROM hr_organization_information inf

246: FROM per_org_structure_versions sv
247: WHERE sv.organization_structure_id in
248: (
249: SELECT TO_NUMBER(inf.org_information1) organization_structure_id
250: FROM hr_organization_information inf
251: WHERE inf.organization_id = v_bg_id
252: AND inf.org_information_context = 'NL_BG_INFO'
253: AND inf.org_information1 IS NOT NULL
254: )