APPS.HXC_RPT_TC_AUDIT_TRAIL dependencies on FND_USER

Line 171: SELECT fnd.user_name||' ['||ppf.full_name||']'

167:
168: lp_sysdate := TO_CHAR(SYSDATE,'dd-Mon-yyyy HH:MI:SS ');
169:
170:
171: SELECT fnd.user_name||' ['||ppf.full_name||']'
172: INTO lp_user
173: FROM per_all_people_f ppf,
174: fnd_user fnd
175: WHERE ppf.person_id = fnd.employee_id

Line 174: fnd_user fnd

170:
171: SELECT fnd.user_name||' ['||ppf.full_name||']'
172: INTO lp_user
173: FROM per_all_people_f ppf,
174: fnd_user fnd
175: WHERE ppf.person_id = fnd.employee_id
176: AND SYSDATE BETWEEN ppf.effective_start_date
177: AND ppf.effective_end_date
178: AND fnd.user_id = FND_GLOBAL.USER_ID;

Line 178: AND fnd.user_id = FND_GLOBAL.USER_ID;

174: fnd_user fnd
175: WHERE ppf.person_id = fnd.employee_id
176: AND SYSDATE BETWEEN ppf.effective_start_date
177: AND ppf.effective_end_date
178: AND fnd.user_id = FND_GLOBAL.USER_ID;
179:
180:
181:
182: IF g_debug

Line 635: fnd.user_name ,

631: p_stop_time DATE )
632: IS SELECT 0 transaction_id,
633: 0 tc_bb_id,
634: hxc.creation_date,
635: fnd.user_name ,
636: NVL(fnd.employee_id,-1),
637: INITCAP(approval_status),
638: DECODE(comment_text,
639: 'LIGHT_APPROVAL','Approval On Submit',

Line 644: fnd_user fnd

640: 'AUTO_APPROVE', 'Auto Approved',
641: comment_text),
642: ' '
643: FROM hxc_time_building_blocks hxc,
644: fnd_user fnd
645: WHERE scope = 'APPLICATION_PERIOD'
646: AND resource_id = p_resource_id
647: AND p_start_time BETWEEN start_time
648: AND stop_time

Line 652: AND fnd.user_id = hxc.created_by

648: AND stop_time
649: AND TRUNC(p_stop_time) BETWEEN start_time
650: AND stop_time
651: AND approval_status IN ('APPROVED','REJECTED')
652: AND fnd.user_id = hxc.created_by
653: AND NVL(hxc.comment_text,' ') <> 'TIMED_OUT'
654: AND NVL(hxc.comment_text,' ') <> 'BLANK_NOTIFICATION'
655: ORDER BY hxc.creation_date ;
656:

Line 682: -- Queries against HXC_TIME_BUILDING_BLOCKS and FND_USER

678:
679: BEGIN
680:
681: -- Private Procedure record_approvals
682: -- Queries against HXC_TIME_BUILDING_BLOCKS and FND_USER
683: -- for all the APPLICATION_PERIOD records for this timecard.
684: -- The application periods are joined with BETWEEN & AND
685: -- conditions to pull up those timecards whose Approval period
686: -- spans across multiple timecard periods.

Line 731: -- a null for employee_id in FND_USER, so the person who approved

727: -- Initialize the approver's name to blank.
728: l_approver_name := ' ';
729:
730: -- Do this only if there exists a valid person. -1 here would mean
731: -- a null for employee_id in FND_USER, so the person who approved
732: -- is a dummy person like SYSADMIN.
733:
734: IF l_appr_person_tab(i) <> -1
735: THEN