DBA Data[Home] [Help]

APPS.PAY_GB_MULTI_PAYROLL_RUN dependencies on FND_DATE

Line 126: , ARGUMENT4 => fnd_date.date_to_canonical(V_END_DATE)

122: , SUB_REQUEST => FALSE
123: , ARGUMENT1 => 'RUN'
124: , ARGUMENT2 => PAY_RUN.payroll_id
125: , ARGUMENT3 => V_CONDOLIDATION_SET_ID
126: , ARGUMENT4 => fnd_date.date_to_canonical(V_END_DATE)
127: , ARGUMENT5 => fnd_date.date_to_canonical(V_REGULAR_PAY_DATE)
128: , ARGUMENT6 => P_ELEMENT_SET_NAME
129: , ARGUMENT7 => l_ARGUMENT7
130: , ARGUMENT8 => TO_NUMBER(P_RUN_TYPE)

Line 127: , ARGUMENT5 => fnd_date.date_to_canonical(V_REGULAR_PAY_DATE)

123: , ARGUMENT1 => 'RUN'
124: , ARGUMENT2 => PAY_RUN.payroll_id
125: , ARGUMENT3 => V_CONDOLIDATION_SET_ID
126: , ARGUMENT4 => fnd_date.date_to_canonical(V_END_DATE)
127: , ARGUMENT5 => fnd_date.date_to_canonical(V_REGULAR_PAY_DATE)
128: , ARGUMENT6 => P_ELEMENT_SET_NAME
129: , ARGUMENT7 => l_ARGUMENT7
130: , ARGUMENT8 => TO_NUMBER(P_RUN_TYPE)
131: , ARGUMENT9 => l_ARGUMENT9

Line 466: AND PTP.START_DATE>=FND_DATE.CANONICAL_TO_DATE(P_START_DATE)

462: WHERE PPP.ASSIGNMENT_ACTION_ID=PAA.ASSIGNMENT_ACTION_ID
463: AND PAA.ASSIGNMENT_ID=PAAF.ASSIGNMENT_ID
464: AND PAAF.PAYROLL_ID=PTP.PAYROLL_ID
465: AND PAAF.PAYROLL_ID=P_PAYROLL_ID
466: AND PTP.START_DATE>=FND_DATE.CANONICAL_TO_DATE(P_START_DATE)
467: AND PTP.END_DATE<=FND_DATE.CANONICAL_TO_DATE(P_END_DATE)
468: AND POPMF.ORG_PAYMENT_METHOD_NAME='Cheque'
469: AND PPP.ORG_PAYMENT_METHOD_ID=POPMF.ORG_PAYMENT_METHOD_ID;
470:

Line 467: AND PTP.END_DATE<=FND_DATE.CANONICAL_TO_DATE(P_END_DATE)

463: AND PAA.ASSIGNMENT_ID=PAAF.ASSIGNMENT_ID
464: AND PAAF.PAYROLL_ID=PTP.PAYROLL_ID
465: AND PAAF.PAYROLL_ID=P_PAYROLL_ID
466: AND PTP.START_DATE>=FND_DATE.CANONICAL_TO_DATE(P_START_DATE)
467: AND PTP.END_DATE<=FND_DATE.CANONICAL_TO_DATE(P_END_DATE)
468: AND POPMF.ORG_PAYMENT_METHOD_NAME='Cheque'
469: AND PPP.ORG_PAYMENT_METHOD_ID=POPMF.ORG_PAYMENT_METHOD_ID;
470:
471: