APPS.PJI_PMV_UTIL dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 1029: per_org_structure_elements orgd

1025: , org.name
1026: , orgd.organization_id_parent)
1027: BULK COLLECT INTO l_Organization_List
1028: FROM
1029: per_org_structure_elements orgd
1030: , pji_system_settings pset
1031: , hr_all_organization_units_tl org
1032: WHERE 1=1
1033: AND orgd.org_structure_version_id = pset.org_structure_version_id

Line 1049: per_org_structure_elements orgd

1045: , org.name
1046: , orgd.organization_id_parent)
1047: BULK COLLECT INTO l_Organization_List
1048: FROM
1049: per_org_structure_elements orgd
1050: , pji_system_settings pset
1051: , per_organization_list sec
1052: , hr_all_organization_units_tl org
1053: WHERE 1=1

Line 1072: per_org_structure_elements orgd

1068: , org.name
1069: , orgd.organization_id_parent)
1070: BULK COLLECT INTO l_Organization_List
1071: FROM
1072: per_org_structure_elements orgd
1073: , pji_system_settings pset
1074: , hr_all_organization_units_tl org
1075: WHERE 1=1
1076: AND orgd.org_structure_version_id = pset.org_structure_version_id

Line 1098: per_org_structure_elements p

1094: , org.name name
1095: , orgd.organization_id_parent organization_id_parent
1096: FROM
1097: (select distinct organization_id_parent organization_id_child, NULL organization_id_parent from
1098: per_org_structure_elements p
1099: , pji_system_settings pset
1100: where p.org_structure_version_id = pset.org_structure_version_id
1101: and not exists
1102: (select 1 from

Line 1103: per_org_structure_elements c

1099: , pji_system_settings pset
1100: where p.org_structure_version_id = pset.org_structure_version_id
1101: and not exists
1102: (select 1 from
1103: per_org_structure_elements c
1104: where c.organization_id_child = p.organization_id_parent
1105: and c.org_structure_version_id = p.org_structure_version_id)) orgd
1106: , per_organization_list sec
1107: , hr_all_organization_units_tl org

Line 1171: per_org_structure_elements orgd

1167: IF l_top_organization_id = 0 THEN
1168: SELECT p_org_id INTO l_org_id FROM DUAL WHERE EXISTS
1169: (SELECT orgd.organization_id_child
1170: FROM
1171: per_org_structure_elements orgd
1172: , pji_system_settings pset
1173: , hr_all_organization_units org
1174: WHERE 1=1
1175: AND orgd.org_structure_version_id = pset.org_structure_version_id

Line 1185: per_org_structure_elements orgd

1181:
1182: SELECT p_org_id INTO l_org_id FROM DUAL WHERE EXISTS
1183: (SELECT orgd.organization_id_child
1184: FROM
1185: per_org_structure_elements orgd
1186: , pji_system_settings pset
1187: , per_organization_list sec
1188: , hr_all_organization_units org
1189: WHERE 1=1

Line 1202: per_org_structure_elements orgd

1198:
1199: SELECT p_org_id INTO l_org_id FROM DUAL WHERE EXISTS
1200: (SELECT orgd.organization_id_child
1201: FROM
1202: per_org_structure_elements orgd
1203: , pji_system_settings pset
1204: , hr_all_organization_units org
1205: WHERE 1=1
1206: AND orgd.org_structure_version_id = pset.org_structure_version_id

Line 1230: per_org_structure_elements p

1226: SELECT p_org_id INTO l_org_id FROM DUAL WHERE EXISTS
1227: (SELECT orgd.organization_id_child
1228: FROM
1229: (select distinct organization_id_parent organization_id_child, NULL organization_id_parent from
1230: per_org_structure_elements p
1231: , pji_system_settings pset
1232: where p.org_structure_version_id = pset.org_structure_version_id
1233: and not exists
1234: (select 1 from

Line 1235: per_org_structure_elements c

1231: , pji_system_settings pset
1232: where p.org_structure_version_id = pset.org_structure_version_id
1233: and not exists
1234: (select 1 from
1235: per_org_structure_elements c
1236: where c.organization_id_child = p.organization_id_parent
1237: and c.org_structure_version_id = p.org_structure_version_id)) orgd
1238: , per_organization_list sec
1239: , hr_all_organization_units org