APPS.PAY_P45_PKG dependencies on FND_DATE

Line 234: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(pact.effective_date)

230: 'TOWN_OR_CITY=P',
231: upper(nvl(max(decode(fue.user_entity_name,
232: 'X_TOWN_OR_CITY',
233: substr(fai.VALUE,1,35))),' ')),
234: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(pact.effective_date)
235: FROM pay_assignment_actions act_edi,
236: pay_action_interlocks pai,
237: pay_assignment_actions act,
238: pay_payroll_actions pact,

Line 251: act.action_status, fnd_date.date_to_canonical(pact.effective_date)

247: AND fai.archive_type <> 'PA'
248: AND fai.user_entity_id = fue.user_entity_id
249: GROUP BY act.assignment_action_id, pay_gb_eoy_archive.get_parameter
250: (pact.legislative_parameters,'CHAR_ERROR'),
251: act.action_status, fnd_date.date_to_canonical(pact.effective_date)
252: ORDER BY 12;
253: /* Addition for P45PT1 ( Bug 6345375 ) ends*/
254: --
255: /* Added for P45PT1 Ver6 changes starts */

Line 331: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(pact.effective_date)

327: 'TOWN_OR_CITY=P',
328: upper(nvl(max(decode(fue.user_entity_name,
329: 'X_TOWN_OR_CITY',
330: substr(fai.VALUE,1,35))),' ')),
331: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(pact.effective_date)
332: FROM pay_assignment_actions act_edi,
333: pay_action_interlocks pai,
334: pay_assignment_actions act,
335: pay_payroll_actions pact,

Line 348: act.action_status, fnd_date.date_to_canonical(pact.effective_date)

344: AND fai.archive_type <> 'PA'
345: AND fai.user_entity_id = fue.user_entity_id
346: GROUP BY act.assignment_action_id, pay_gb_eoy_archive.get_parameter
347: (pact.legislative_parameters,'CHAR_ERROR'),
348: act.action_status, fnd_date.date_to_canonical(pact.effective_date)
349: ORDER BY 12;
350: --
351: --
352: level_cnt number; -- required by the generic magtape procedure.