APPS.PAY_RETRO_UTILS_PKG dependencies on FND_USER

Line 387: from fnd_user

383: --
384:
385: cursor csr_usr_name (cp_usr_id number) is
386: select user_name
387: from fnd_user
388: where user_id = cp_usr_id
389: and sysdate between start_date and nvl(end_date,hr_api.g_eot);
390:
391: cursor csr_upd_row_info (cp_ppe_id number) is

Line 403: l_usr_id fnd_user.user_id%type;

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:
407: l_table_name varchar2(80);

Line 404: l_user fnd_user.user_name%type := 'ANONYMOUS';

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:
407: l_table_name varchar2(80);
408: l_column_name varchar2(80);