APPS.PER_PERUSEO1_XMLP_PKG dependencies on HR_LOCATIONS_ALL

Line 98: HR_LOCATIONS_ALL ELOC

94: FROM
95: HR_LOCATION_EXTRA_INFO HLEI1,
96: HR_LOCATION_EXTRA_INFO HLEI2,
97: PER_GEN_HIERARCHY_NODES PGN,
98: HR_LOCATIONS_ALL ELOC
99: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
100: AND PGN.NODE_TYPE = 'EST'
101: AND ELOC.LOCATION_ID = PGN.ENTITY_ID
102: AND HLEI1.LOCATION_ID = ELOC.LOCATION_ID

Line 126: HR_LOCATIONS_ALL ELOC

122: INTO L_LOCATION_ID,L_LOCATION_CODE
123: FROM
124: HR_LOCATION_EXTRA_INFO HLEI1,
125: PER_GEN_HIERARCHY_NODES PGN,
126: HR_LOCATIONS_ALL ELOC
127: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
128: AND PGN.NODE_TYPE = 'EST'
129: AND ELOC.LOCATION_ID = PGN.ENTITY_ID
130: AND HLEI1.LOCATION_ID = ELOC.LOCATION_ID

Line 166: HR_LOCATIONS_ALL ELOC

162: INTO L_DUMMY,L_LOCATION_ID,L_LOCATION_CODE
163: FROM
164: HR_LOCATION_EXTRA_INFO HLEI1,
165: PER_GEN_HIERARCHY_NODES PGN,
166: HR_LOCATIONS_ALL ELOC
167: WHERE PGN.HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
168: AND PGN.NODE_TYPE = 'EST'
169: AND ELOC.LOCATION_ID = PGN.ENTITY_ID
170: AND HLEI1.LOCATION_ID = ELOC.LOCATION_ID

Line 694: HR_LOCATIONS_ALL ELOC

690: ELOC.LOCATION_CODE
691: INTO L_LOCATION_ID,L_LOCATION_CODE
692: FROM
693: PER_GEN_HIERARCHY_NODES PGN,
694: HR_LOCATIONS_ALL ELOC
695: WHERE ( HIERARCHY_NODE_ID = EST_NODE_ID
696: OR PARENT_HIERARCHY_NODE_ID = EST_NODE_ID )
697: AND HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID
698: AND PGN.NODE_TYPE = 'EST'

Line 857: HR_LOCATIONS_ALL HL

853: FROM
854: PER_ALL_PEOPLE_F PEO,
855: PER_ALL_ASSIGNMENTS_F ASS,
856: PER_JOBS_VL JOB,
857: HR_LOCATIONS_ALL HL
858: WHERE PEO.PERSON_ID = ASS.PERSON_ID
859: AND PEO.PER_INFORMATION1 is not null
860: AND PEO.PER_INFORMATION_CATEGORY = 'US'
861: AND JOB.JOB_INFORMATION_CATEGORY = 'US'