APPS.PQP_NL_PENSION_EXTRACTS dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 2732: FROM per_org_structure_elements a

2728: c_org_struct_ver_id per_org_structure_versions_v.org_structure_version_id%TYPE
2729: ) IS
2730: SELECT os.organization_id_child
2731: FROM (SELECT *
2732: FROM per_org_structure_elements a
2733: WHERE a.org_structure_version_id = c_org_struct_ver_id ) os
2734: WHERE os.organization_id_parent = c_org_id;
2735:
2736:

Line 2751: FROM per_org_structure_elements a

2747: c_org_struct_ver_id per_org_structure_versions_v.org_structure_version_id%TYPE
2748: ) IS
2749: SELECT 'x'
2750: FROM (SELECT *
2751: FROM per_org_structure_elements a
2752: WHERE a.org_structure_version_id = c_org_struct_ver_id ) os
2753: WHERE os.organization_id_parent = c_org_id;
2754:
2755: l_error_message Varchar2(10);

Line 5545: FROM per_org_structure_elements a

5541: CURSOR c_get_children ( c_org_str_ver_id IN Number
5542: ,c_org_id IN Number) IS
5543: SELECT os.organization_id_child
5544: FROM (SELECT *
5545: FROM per_org_structure_elements a
5546: WHERE a.org_structure_version_id = c_org_str_ver_id ) os
5547: START WITH os.organization_id_parent = c_org_id
5548: CONNECT BY os.organization_id_parent = PRIOR os.organization_id_child;
5549: --

Line 6551: FROM per_org_structure_elements

6547: --
6548: CURSOR c_find_parent_id(c_org_id in number
6549: ,c_version_id in number) IS
6550: SELECT organization_id_parent
6551: FROM per_org_structure_elements
6552: WHERE organization_id_child = c_org_id
6553: AND org_structure_version_id = c_version_id
6554: AND business_group_id = p_business_group_id;
6555:

Line 9037: FROM per_org_structure_elements

9033: --Cursor to find the parent id from the org id
9034: CURSOR c_find_parent_id(c_org_id IN Number
9035: ,c_version_id IN Number) IS
9036: SELECT organization_id_parent
9037: FROM per_org_structure_elements
9038: WHERE organization_id_child = c_org_id
9039: AND org_structure_version_id = c_version_id
9040: AND business_group_id = p_business_group_id;
9041:

Line 9348: FROM per_org_structure_elements

9344: --Cursor to find the parent id from the org id
9345: CURSOR c_find_parent_id(c_org_id IN Number
9346: ,c_version_id IN Number) IS
9347: SELECT organization_id_parent
9348: FROM per_org_structure_elements
9349: WHERE organization_id_child = c_org_id
9350: AND org_structure_version_id = c_version_id
9351: AND business_group_id = p_business_group_id;
9352:

Line 9563: FROM per_org_structure_elements

9559: --Cursor to find the parent id from the org id
9560: CURSOR c_find_parent_id(c_org_id IN Number
9561: ,c_version_id IN Number) IS
9562: SELECT organization_id_parent
9563: FROM per_org_structure_elements
9564: WHERE organization_id_child = c_org_id
9565: AND org_structure_version_id = c_version_id
9566: AND business_group_id = p_business_group_id;
9567:

Line 11923: FROM per_org_structure_elements

11919: --Cursor to find the parent id from the org id
11920: CURSOR c_find_parent_id(c_org_id IN Number
11921: ,c_version_id IN Number) IS
11922: SELECT organization_id_parent
11923: FROM per_org_structure_elements
11924: WHERE organization_id_child = c_org_id
11925: AND org_structure_version_id = c_version_id
11926: AND business_group_id = p_business_group_id;
11927: