APPS.PAY_RETRO_UTILS_PKG dependencies on PAY_PROCESS_EVENTS

Line 395: from pay_process_events ppe

391: cursor csr_upd_row_info (cp_ppe_id number) is
392: select pdt.table_name,peu.column_name,
393: pdt.start_date_name,pdt.end_date_name,
394: pdt.surrogate_key_name,ppe.surrogate_key,ppe.effective_date
395: from pay_process_events ppe
396: ,Pay_event_updates peu
397: ,pay_dated_tables pdt
398: where ppe.process_event_id = cp_ppe_id
399: and ppe.event_update_id = peu.event_update_id

Line 402: l_ppe_id pay_process_events.process_event_id%type;

398: where ppe.process_event_id = cp_ppe_id
399: and ppe.event_update_id = peu.event_update_id
400: and peu.dated_table_id = pdt.dated_table_id;
401:
402: l_ppe_id pay_process_events.process_event_id%type;
403: l_usr_id fnd_user.user_id%type;
404: l_user fnd_user.user_name%type := 'ANONYMOUS';
405: l_statement varchar2(2000);
406: