APPS.PER_PERUSEO1_XMLP_PKG dependencies on HR_LOCATIONS_ALL

Line 239: HR_LOCATIONS_ALL ELOC

235: FROM
236: HR_LOCATION_EXTRA_INFO HLEI1,
237: HR_LOCATION_EXTRA_INFO HLEI2,
238: PER_GEN_HIERARCHY_NODES PGN,
239: HR_LOCATIONS_ALL ELOC
240: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
241: AND PGN.NODE_TYPE = 'EST'
242: AND ELOC.LOCATION_ID = PGN.ENTITY_ID
243: AND HLEI1.LOCATION_ID = ELOC.LOCATION_ID

Line 267: HR_LOCATIONS_ALL ELOC

263: INTO L_LOCATION_ID,L_LOCATION_CODE
264: FROM
265: HR_LOCATION_EXTRA_INFO HLEI1,
266: PER_GEN_HIERARCHY_NODES PGN,
267: HR_LOCATIONS_ALL ELOC
268: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
269: AND PGN.NODE_TYPE = 'EST'
270: AND ELOC.LOCATION_ID = PGN.ENTITY_ID
271: AND HLEI1.LOCATION_ID = ELOC.LOCATION_ID

Line 307: HR_LOCATIONS_ALL ELOC

303: INTO L_DUMMY,L_LOCATION_ID,L_LOCATION_CODE
304: FROM
305: HR_LOCATION_EXTRA_INFO HLEI1,
306: PER_GEN_HIERARCHY_NODES PGN,
307: HR_LOCATIONS_ALL ELOC
308: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
309: AND PGN.NODE_TYPE = 'EST'
310: AND ELOC.LOCATION_ID = PGN.ENTITY_ID
311: AND HLEI1.LOCATION_ID = ELOC.LOCATION_ID

Line 1057: L_LOCATION_CODE HR_LOCATIONS_ALL.LOCATION_CODE%TYPE; -- changed declaration for #13785825

1053: PRAGMA AUTONOMOUS_TRANSACTION; /*Added for Bug#12599302 */
1054: P_UPDATE VARCHAR2(1) := 'C';
1055: L_LOCATION_ID VARCHAR2(60);
1056: -- L_LOCATION_CODE VARCHAR2(50); Commented for fix of #13785825
1057: L_LOCATION_CODE HR_LOCATIONS_ALL.LOCATION_CODE%TYPE; -- changed declaration for #13785825
1058: L_LOCATION_EXTRA_INFO_ID NUMBER := NULL;
1059: L_OBJECT_VERSION_NUMBER NUMBER := NULL;
1060: L_EIT_COUNT NUMBER := 0;
1061: L_MIN_YEAR VARCHAR2(4) := NULL;

Line 1075: HR_LOCATIONS_ALL ELOC

1071: ELOC.LOCATION_CODE
1072: INTO L_LOCATION_ID,L_LOCATION_CODE
1073: FROM
1074: PER_GEN_HIERARCHY_NODES PGN,
1075: HR_LOCATIONS_ALL ELOC
1076: WHERE ( HIERARCHY_NODE_ID = EST_NODE_ID
1077: OR PARENT_HIERARCHY_NODE_ID = EST_NODE_ID )
1078: AND HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
1079: AND PGN.NODE_TYPE = 'EST'

Line 1244: HR_LOCATIONS_ALL HL

1240: PER_ALL_PEOPLE_F PEO,
1241: PER_ALL_ASSIGNMENTS_F ASS,
1242: --PER_JOBS_VL JOB, - Replaced PER_JOBS_VL with PER_JOBS -bug#11736960
1243: PER_JOBS JOB,
1244: HR_LOCATIONS_ALL HL
1245: WHERE PEO.PERSON_ID = ASS.PERSON_ID
1246: --
1247: /* Commented for bug#11736960 starts
1248: AND PEO.PER_INFORMATION1 is not null