DBA Data[Home] [Help]

APPS.PAY_RETRO_UTILS_PKG dependencies on FND_USER

Line 417: from fnd_user

413: --
414:
415: cursor csr_usr_name (cp_usr_id number) is
416: select user_name
417: from fnd_user
418: where user_id = cp_usr_id
419: and sysdate between start_date and nvl(end_date,hr_api.g_eot);
420:
421: cursor csr_upd_row_info (cp_ppe_id number) is

Line 433: l_usr_id fnd_user.user_id%type;

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

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

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