APPS.PAY_RETRO_UTILS_PKG dependencies on PAY_PROCESS_EVENTS

Line 425: from pay_process_events ppe

421: cursor csr_upd_row_info (cp_ppe_id number) is
422: select pdt.table_name,peu.column_name,
423: pdt.start_date_name,pdt.end_date_name,
424: pdt.surrogate_key_name,ppe.surrogate_key,ppe.effective_date
425: from pay_process_events ppe
426: ,Pay_event_updates peu
427: ,pay_dated_tables pdt
428: where ppe.process_event_id = cp_ppe_id
429: and ppe.event_update_id = peu.event_update_id

Line 432: l_ppe_id pay_process_events.process_event_id%type;

428: where ppe.process_event_id = cp_ppe_id
429: and ppe.event_update_id = peu.event_update_id
430: and peu.dated_table_id = pdt.dated_table_id;
431:
432: l_ppe_id pay_process_events.process_event_id%type;
433: l_usr_id fnd_user.user_id%type;
434: l_user fnd_user.user_name%type := 'ANONYMOUS';
435: l_statement varchar2(2000);
436: