DBA Data[Home] [Help]

APPS.PAY_PAYCABPS_XMLP_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 298: PAY_ALL_PAYROLLS_F PPF2

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
302: ,10))

Line 411: PAY_ALL_PAYROLLS_F PPF2

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
415: ,10))

Line 557: PAY_ALL_PAYROLLS_F PPF2

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
561: ,10))

Line 703: PAY_ALL_PAYROLLS_F PPF2

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
707: ,10))