APPS.PAY_PRG_PROCESS_EVENTS dependencies on FND_DATE

Line 474: where ppe.creation_date < fnd_date.canonical_to_date(p_purge_date)

470: /* Cursor that defines what data to purge and archive */
471: cursor get_archive_events is
472: select ppe.*
473: from pay_process_events ppe
474: where ppe.creation_date < fnd_date.canonical_to_date(p_purge_date)
475: and ppe.assignment_id between x_start_id and x_end_id
476: and (not exists
477: (select 1
478: from pay_recorded_requests prr