APPS.PAY_NL_REM_REPORT dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 907: FROM per_org_structure_elements pose

903: ,'Y') = 'Y'
904: AND EXISTS
905: (
906: SELECT hou1.organization_id
907: FROM per_org_structure_elements pose
908: WHERE (
909: pose.organization_id_child = hou1.organization_id
910: OR pose.organization_id_parent = hou1.organization_id
911: )

Line 933: FROM per_org_structure_elements pose

929: FROM hr_organization_information e
930: WHERE e.organization_id IN
931: (
932: SELECT pose.organization_id_child employer
933: FROM per_org_structure_elements pose
934: WHERE pose.org_structure_version_id = l_org_struct_version_id
935: START WITH pose.organization_id_parent = nvl (p_top_org_id
936: ,p_business_group_id)
937: CONNECT BY NOCYCLE PRIOR pose.organization_id_child = pose.organization_id_parent

Line 1040: FROM per_org_structure_elements pose1

1036: AND ( (NVL(paa.establishment_id,ppf.prl_information1) = c_tax_org_id) OR
1037: NVL(paa.establishment_id,ppf.prl_information1) IN
1038: ( SELECT DISTINCT
1039: pose1.organization_id_child employer
1040: FROM per_org_structure_elements pose1
1041: WHERE pose1.org_structure_version_id = l_org_struct_version_id
1042: AND pose1.organization_id_parent = c_tax_org_id
1043: AND pose1.organization_id_child NOT IN
1044: (