DBA Data[Home] [Help]

APPS.PAY_PAYCABPS_XMLP_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 291: PAY_PAYROLL_ACTIONS PPA,

287: PER_PAY_BASES PPB,
288: PER_ALL_ASSIGNMENTS_F PAF,
289: PAY_PAYROLLS_F PP,
290: PAY_ASSIGNMENT_ACTIONS PAA,
291: PAY_PAYROLL_ACTIONS PPA,
292: PER_TIME_PERIODS PTP
293: WHERE PTP.TIME_PERIOD_ID in (
294: SELECT
295: MAX(PTP2.TIME_PERIOD_ID)

Line 321: PAY_PAYROLL_ACTIONS PPA2,

317: AND EXISTS (
318: SELECT
319: 'X'
320: FROM
321: PAY_PAYROLL_ACTIONS PPA2,
322: PAY_RUN_TYPES_F PRT
323: WHERE PPA2.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
324: AND NVL(PPA2.RUN_TYPE_ID
325: ,-1) = PRT.RUN_TYPE_ID

Line 404: PAY_PAYROLL_ACTIONS PPA,

400: PER_PAY_BASES PPB,
401: PER_ALL_ASSIGNMENTS_F PAF,
402: PAY_PAYROLLS_F PP,
403: PAY_ASSIGNMENT_ACTIONS PAA,
404: PAY_PAYROLL_ACTIONS PPA,
405: PER_TIME_PERIODS PTP
406: WHERE PTP.TIME_PERIOD_ID in (
407: SELECT
408: MAX(PTP2.TIME_PERIOD_ID)

Line 434: PAY_PAYROLL_ACTIONS PPA2,

430: AND EXISTS (
431: SELECT
432: 'X'
433: FROM
434: PAY_PAYROLL_ACTIONS PPA2,
435: PAY_RUN_TYPES_F PRT
436: WHERE PPA2.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
437: AND NVL(PPA2.RUN_TYPE_ID
438: ,-1) = PRT.RUN_TYPE_ID

Line 550: PAY_PAYROLL_ACTIONS PPA,

546: PER_PAY_BASES PPB,
547: PER_ALL_ASSIGNMENTS_F PAF,
548: PAY_PAYROLLS_F PP,
549: PAY_ASSIGNMENT_ACTIONS PAA,
550: PAY_PAYROLL_ACTIONS PPA,
551: PER_TIME_PERIODS PTP
552: WHERE PTP.TIME_PERIOD_ID in (
553: SELECT
554: MAX(PTP2.TIME_PERIOD_ID)

Line 579: PAY_PAYROLL_ACTIONS PPA2,

575: AND EXISTS (
576: SELECT
577: 'X'
578: FROM
579: PAY_PAYROLL_ACTIONS PPA2,
580: PAY_RUN_TYPES_F PRT
581: WHERE PPA2.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
582: AND NVL(PPA2.RUN_TYPE_ID
583: ,-1) = PRT.RUN_TYPE_ID

Line 696: PAY_PAYROLL_ACTIONS PPA,

692: PER_PAY_BASES PPB,
693: PER_ALL_ASSIGNMENTS_F PAF,
694: PAY_PAYROLLS_F PP,
695: PAY_ASSIGNMENT_ACTIONS PAA,
696: PAY_PAYROLL_ACTIONS PPA,
697: PER_TIME_PERIODS PTP
698: WHERE PTP.TIME_PERIOD_ID in (
699: SELECT
700: MAX(PTP2.TIME_PERIOD_ID)

Line 725: PAY_PAYROLL_ACTIONS PPA2,

721: AND EXISTS (
722: SELECT
723: 'X'
724: FROM
725: PAY_PAYROLL_ACTIONS PPA2,
726: PAY_RUN_TYPES_F PRT
727: WHERE PPA2.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
728: AND NVL(PPA2.RUN_TYPE_ID
729: ,-1) = PRT.RUN_TYPE_ID