DBA Data[Home] [Help]

APPS.PAY_NL_NSI_PROCESS dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 1889: per_org_structure_elements pose

1885: and (paa.payroll_id = lp_payroll_id OR lp_payroll_id IS NULL)
1886: and paa.person_id =pap.person_id
1887: and paa.organization_id IN (
1888: SELECT pose.organization_id_child FROM
1889: per_org_structure_elements pose
1890: CONNECT BY pose.organization_id_parent = prior pose.organization_id_child
1891: AND pose.org_structure_version_id =lp_structure_version_id
1892: START WITH pose.organization_id_parent=lp_employer_id
1893: AND pose.org_structure_version_id =lp_structure_version_id