DBA Data[Home] [Help]

APPS.PAY_PAYCABPS_XMLP_PKG dependencies on PER_TIME_PERIODS

Line 292: PER_TIME_PERIODS PTP

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)
296: FROM

Line 297: PER_TIME_PERIODS PTP2,

293: WHERE PTP.TIME_PERIOD_ID in (
294: SELECT
295: MAX(PTP2.TIME_PERIOD_ID)
296: FROM
297: PER_TIME_PERIODS PTP2,
298: PAY_ALL_PAYROLLS_F PPF2
299: WHERE TO_CHAR(PTP2.END_DATE
300: ,'YYYY/MM') = TO_CHAR(FND_DATE.CANONICAL_TO_DATE(SUBSTR(P_CANONICAL_REFERENCE_MONTH
301: ,1

Line 405: PER_TIME_PERIODS PTP

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)
409: FROM

Line 410: PER_TIME_PERIODS PTP2,

406: WHERE PTP.TIME_PERIOD_ID in (
407: SELECT
408: MAX(PTP2.TIME_PERIOD_ID)
409: FROM
410: PER_TIME_PERIODS PTP2,
411: PAY_ALL_PAYROLLS_F PPF2
412: WHERE TO_CHAR(PTP2.END_DATE
413: ,'YYYY/MM') = TO_CHAR(FND_DATE.CANONICAL_TO_DATE(SUBSTR(P_CANONICAL_REFERENCE_MONTH
414: ,1

Line 551: PER_TIME_PERIODS PTP

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)
555: FROM

Line 556: PER_TIME_PERIODS PTP2,

552: WHERE PTP.TIME_PERIOD_ID in (
553: SELECT
554: MAX(PTP2.TIME_PERIOD_ID)
555: FROM
556: PER_TIME_PERIODS PTP2,
557: PAY_ALL_PAYROLLS_F PPF2
558: WHERE TO_CHAR(PTP2.END_DATE
559: ,'YYYY/MM') = TO_CHAR(FND_DATE.CANONICAL_TO_DATE(SUBSTR(P_CANONICAL_REFERENCE_MONTH
560: ,1

Line 697: PER_TIME_PERIODS PTP

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)
701: FROM

Line 702: PER_TIME_PERIODS PTP2,

698: WHERE PTP.TIME_PERIOD_ID in (
699: SELECT
700: MAX(PTP2.TIME_PERIOD_ID)
701: FROM
702: PER_TIME_PERIODS PTP2,
703: PAY_ALL_PAYROLLS_F PPF2
704: WHERE TO_CHAR(PTP2.END_DATE
705: ,'YYYY/MM') = TO_CHAR(FND_DATE.CANONICAL_TO_DATE(SUBSTR(P_CANONICAL_REFERENCE_MONTH
706: ,1