APPS.PQP_NL_PENSION_EXTRACTS dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 2753: FROM per_org_structure_elements a

2749: c_org_struct_ver_id per_org_structure_versions_v.org_structure_version_id%TYPE
2750: ) IS
2751: SELECT os.organization_id_child
2752: FROM (SELECT *
2753: FROM per_org_structure_elements a
2754: WHERE a.org_structure_version_id = c_org_struct_ver_id ) os
2755: WHERE os.organization_id_parent = c_org_id;
2756:
2757:

Line 2772: FROM per_org_structure_elements a

2768: c_org_struct_ver_id per_org_structure_versions_v.org_structure_version_id%TYPE
2769: ) IS
2770: SELECT 'x'
2771: FROM (SELECT *
2772: FROM per_org_structure_elements a
2773: WHERE a.org_structure_version_id = c_org_struct_ver_id ) os
2774: WHERE os.organization_id_parent = c_org_id;
2775:
2776: l_error_message Varchar2(10);

Line 5734: FROM per_org_structure_elements a

5730: CURSOR c_get_children ( c_org_str_ver_id IN Number
5731: ,c_org_id IN Number) IS
5732: SELECT os.organization_id_child
5733: FROM (SELECT *
5734: FROM per_org_structure_elements a
5735: WHERE a.org_structure_version_id = c_org_str_ver_id ) os
5736: START WITH os.organization_id_parent = c_org_id
5737: CONNECT BY os.organization_id_parent = PRIOR os.organization_id_child;
5738: --

Line 6889: FROM per_org_structure_elements

6885: --
6886: CURSOR c_find_parent_id(c_org_id in number
6887: ,c_version_id in number) IS
6888: SELECT organization_id_parent
6889: FROM per_org_structure_elements
6890: WHERE organization_id_child = c_org_id
6891: AND org_structure_version_id = c_version_id
6892: AND business_group_id = p_business_group_id;
6893:

Line 9376: FROM per_org_structure_elements

9372: --Cursor to find the parent id from the org id
9373: CURSOR c_find_parent_id(c_org_id IN Number
9374: ,c_version_id IN Number) IS
9375: SELECT organization_id_parent
9376: FROM per_org_structure_elements
9377: WHERE organization_id_child = c_org_id
9378: AND org_structure_version_id = c_version_id
9379: AND business_group_id = p_business_group_id;
9380:

Line 9687: FROM per_org_structure_elements

9683: --Cursor to find the parent id from the org id
9684: CURSOR c_find_parent_id(c_org_id IN Number
9685: ,c_version_id IN Number) IS
9686: SELECT organization_id_parent
9687: FROM per_org_structure_elements
9688: WHERE organization_id_child = c_org_id
9689: AND org_structure_version_id = c_version_id
9690: AND business_group_id = p_business_group_id;
9691:

Line 9902: FROM per_org_structure_elements

9898: --Cursor to find the parent id from the org id
9899: CURSOR c_find_parent_id(c_org_id IN Number
9900: ,c_version_id IN Number) IS
9901: SELECT organization_id_parent
9902: FROM per_org_structure_elements
9903: WHERE organization_id_child = c_org_id
9904: AND org_structure_version_id = c_version_id
9905: AND business_group_id = p_business_group_id;
9906:

Line 12292: FROM per_org_structure_elements

12288: --Cursor to find the parent id from the org id
12289: CURSOR c_find_parent_id(c_org_id IN Number
12290: ,c_version_id IN Number) IS
12291: SELECT organization_id_parent
12292: FROM per_org_structure_elements
12293: WHERE organization_id_child = c_org_id
12294: AND org_structure_version_id = c_version_id
12295: AND business_group_id = p_business_group_id;
12296: