DBA Data[Home] [Help]

APPS.PAY_NL_IZA_UPLOAD dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 192: FROM per_org_structure_elements pose

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
195: from pay_nl_iza_upld_status piza
196: where piza.process_year_month = v_period_End_Date

Line 206: FROM per_org_structure_elements pose

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
209: from pay_nl_iza_upld_status piza
210: where piza.process_year_month = v_period_End_Date