APPS.PAY_PAYCABPS_XMLP_PKG dependencies on FND_DATE

Line 56: TO_CHAR(TRUNC(FND_DATE.CANONICAL_TO_DATE(SUBSTR(P_CANONICAL_REFERENCE_MONTH

52: RAISE_APPLICATION_ERROR(-20101
53: ,NULL);
54: ELSE
55: SELECT
56: TO_CHAR(TRUNC(FND_DATE.CANONICAL_TO_DATE(SUBSTR(P_CANONICAL_REFERENCE_MONTH
57: ,1
58: ,10))
59: ,'MM')
60: ,'DD/MM'),

Line 61: TO_CHAR(LAST_DAY(FND_DATE.CANONICAL_TO_DATE(SUBSTR(P_CANONICAL_REFERENCE_MONTH

57: ,1
58: ,10))
59: ,'MM')
60: ,'DD/MM'),
61: TO_CHAR(LAST_DAY(FND_DATE.CANONICAL_TO_DATE(SUBSTR(P_CANONICAL_REFERENCE_MONTH
62: ,1
63: ,10)))
64: ,'DD/MM'),
65: LAST_DAY(FND_DATE.CANONICAL_TO_DATE(SUBSTR(P_CANONICAL_REFERENCE_MONTH

Line 65: LAST_DAY(FND_DATE.CANONICAL_TO_DATE(SUBSTR(P_CANONICAL_REFERENCE_MONTH

61: TO_CHAR(LAST_DAY(FND_DATE.CANONICAL_TO_DATE(SUBSTR(P_CANONICAL_REFERENCE_MONTH
62: ,1
63: ,10)))
64: ,'DD/MM'),
65: LAST_DAY(FND_DATE.CANONICAL_TO_DATE(SUBSTR(P_CANONICAL_REFERENCE_MONTH
66: ,1
67: ,10))),
68: FND_DATE.CANONICAL_TO_DATE(SUBSTR(P_CANONICAL_REFERENCE_MONTH
69: ,1

Line 68: FND_DATE.CANONICAL_TO_DATE(SUBSTR(P_CANONICAL_REFERENCE_MONTH

64: ,'DD/MM'),
65: LAST_DAY(FND_DATE.CANONICAL_TO_DATE(SUBSTR(P_CANONICAL_REFERENCE_MONTH
66: ,1
67: ,10))),
68: FND_DATE.CANONICAL_TO_DATE(SUBSTR(P_CANONICAL_REFERENCE_MONTH
69: ,1
70: ,10)),
71: LAST_DAY(FND_DATE.CANONICAL_TO_DATE(SUBSTR(P_CANONICAL_REFERENCE_MONTH
72: ,1

Line 71: LAST_DAY(FND_DATE.CANONICAL_TO_DATE(SUBSTR(P_CANONICAL_REFERENCE_MONTH

67: ,10))),
68: FND_DATE.CANONICAL_TO_DATE(SUBSTR(P_CANONICAL_REFERENCE_MONTH
69: ,1
70: ,10)),
71: LAST_DAY(FND_DATE.CANONICAL_TO_DATE(SUBSTR(P_CANONICAL_REFERENCE_MONTH
72: ,1
73: ,10)))
74: INTO
75: L_START_DATE

Line 156: P_REFERENCE_MONTH := TO_CHAR(FND_DATE.CANONICAL_TO_DATE(P_CANONICAL_REFERENCE_MONTH)

152: WHERE ORGANIZATION_ID = CP_GRE
153: AND ORG_INFORMATION_CONTEXT = 'Canada Employer Identification';
154: L_GRE_TYPE VARCHAR2(10);
155: BEGIN
156: P_REFERENCE_MONTH := TO_CHAR(FND_DATE.CANONICAL_TO_DATE(P_CANONICAL_REFERENCE_MONTH)
157: ,'MON-YYYY');
158: IF P_GRE IS NOT NULL THEN
159: BEGIN
160: OPEN C_GRE_TYPE(P_GRE);

Line 300: ,'YYYY/MM') = TO_CHAR(FND_DATE.CANONICAL_TO_DATE(SUBSTR(P_CANONICAL_REFERENCE_MONTH

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))
303: ,'YYYY/MM')
304: AND PPF2.PAYROLL_ID = PTP2.PAYROLL_ID

Line 413: ,'YYYY/MM') = TO_CHAR(FND_DATE.CANONICAL_TO_DATE(SUBSTR(P_CANONICAL_REFERENCE_MONTH

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))
416: ,'YYYY/MM')
417: AND PPF2.PAYROLL_ID = PTP2.PAYROLL_ID

Line 559: ,'YYYY/MM') = TO_CHAR(FND_DATE.CANONICAL_TO_DATE(SUBSTR(P_CANONICAL_REFERENCE_MONTH

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))
562: ,'YYYY/MM')
563: AND PPF2.PAYROLL_ID = PTP2.PAYROLL_ID

Line 705: ,'YYYY/MM') = TO_CHAR(FND_DATE.CANONICAL_TO_DATE(SUBSTR(P_CANONICAL_REFERENCE_MONTH

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))
708: ,'YYYY/MM')
709: AND PPF2.PAYROLL_ID = PTP2.PAYROLL_ID