APPS.PAY_P45_PKG dependencies on FND_DATE

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

221: 'TOWN_OR_CITY=P',
222: upper(nvl(max(decode(fue.user_entity_name,
223: 'X_TOWN_OR_CITY',
224: substr(fai.VALUE,1,35))),' ')),
225: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(pact.effective_date)
226: FROM pay_assignment_actions act_edi,
227: pay_action_interlocks pai,
228: pay_assignment_actions act,
229: pay_payroll_actions pact,

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

238: AND fai.archive_type <> 'PA'
239: AND fai.user_entity_id = fue.user_entity_id
240: GROUP BY act.assignment_action_id, pay_gb_eoy_archive.get_parameter
241: (pact.legislative_parameters,'CHAR_ERROR'),
242: act.action_status, fnd_date.date_to_canonical(pact.effective_date)
243: ORDER BY 12;
244: /* Addition for P45PT1 ( Bug 6345375 ) ends*/
245: --
246: --