APPS.PAY_PAYCABPS_XMLP_PKG dependencies on HR_LOCATIONS

Line 102: HR_LOCATIONS

98: LOCATION_CODE
99: INTO
100: L_LOCATION_CODE
101: FROM
102: HR_LOCATIONS
103: WHERE LOCATION_ID = P_LOCATION;
104: C_LOCATION_CODE := L_LOCATION_CODE;
105: END IF;
106: IF P_GRE IS NOT NULL THEN

Line 227: HR_LOCATIONS

223: LOCATION_CODE
224: INTO
225: L_LOCATION_CODE
226: FROM
227: HR_LOCATIONS
228: WHERE LOCATION_ID = TO_NUMBER(PROV_OR_LOC);
229: CP_LOCATION_CODE := L_LOCATION_CODE;
230: ELSIF P_PROVINCE_OR_LOCATION IS NULL THEN
231: CP_PROVINCE := PROV_OR_LOC;

Line 285: HR_LOCATIONS_ALL HL,

281: ,PPA.BUSINESS_GROUP_ID
282: ,NVL(PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('JURISDICTION_CODE')
283: ,NULL)) REGULAR_GROSS
284: FROM
285: HR_LOCATIONS_ALL HL,
286: PER_ALL_PEOPLE_F PPF,
287: PER_PAY_BASES PPB,
288: PER_ALL_ASSIGNMENTS_F PAF,
289: PAY_PAYROLLS_F PP,

Line 398: HR_LOCATIONS_ALL HL,

394: ,PPA.BUSINESS_GROUP_ID
395: ,NVL(PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('JURISDICTION_CODE')
396: ,NULL)) REGULAR_GROSS
397: FROM
398: HR_LOCATIONS_ALL HL,
399: PER_ALL_PEOPLE_F PPF,
400: PER_PAY_BASES PPB,
401: PER_ALL_ASSIGNMENTS_F PAF,
402: PAY_PAYROLLS_F PP,

Line 544: HR_LOCATIONS_ALL HL,

540: ,NULL)) REGULAR_GROSS,
541: ROUND(((PTP.END_DATE - PTP.START_DATE + 1) / 7)
542: ,2) WEEKS
543: FROM
544: HR_LOCATIONS_ALL HL,
545: PER_ALL_PEOPLE_F PPF,
546: PER_PAY_BASES PPB,
547: PER_ALL_ASSIGNMENTS_F PAF,
548: PAY_PAYROLLS_F PP,

Line 690: HR_LOCATIONS_ALL HL,

686: ,NULL)) REGULAR_GROSS,
687: ROUND(((PTP.END_DATE - PTP.START_DATE + 1) / 7)
688: ,2) WEEKS
689: FROM
690: HR_LOCATIONS_ALL HL,
691: PER_ALL_PEOPLE_F PPF,
692: PER_PAY_BASES PPB,
693: PER_ALL_ASSIGNMENTS_F PAF,
694: PAY_PAYROLLS_F PP,