APPS.HXC_RDB_PRE_RETRIEVAL dependencies on FND_USER

Line 116: fnd_user fnd

112: IS SELECT det.last_updated_by,
113: ROWIDTOCHAR(rdb.rowid)
114: FROM hxc_rdb_pre_timecards rdb,
115: hxc_time_building_blocks det,
116: fnd_user fnd
117: WHERE rdb.ret_user_id = FND_GLOBAL.user_id
118: AND rdb.lu_bb_id = det.time_building_block_id
119: AND rdb.lu_ovn = det.object_version_number
120: AND det.last_updated_by = fnd.user_id

Line 120: AND det.last_updated_by = fnd.user_id

116: fnd_user fnd
117: WHERE rdb.ret_user_id = FND_GLOBAL.user_id
118: AND rdb.lu_bb_id = det.time_building_block_id
119: AND rdb.lu_ovn = det.object_version_number
120: AND det.last_updated_by = fnd.user_id
121: AND fnd.employee_id <> det.resource_id
122: ;
123:
124: usertab VARCHARTAB;

Line 643: fnd_user fnd,

639: IS SELECT ppf.full_name,
640: ppf.person_id,
641: ROWIDTOCHAR(rdb.rowid)
642: FROM hxc_rdb_pre_updated rdb,
643: fnd_user fnd,
644: per_people_f ppf -- Bug 12605349
645: WHERE rdb.ret_user_id = FND_GLOBAL.user_id
646: AND rdb.last_updated_by = fnd.user_id
647: AND fnd.employee_id = ppf.person_id

Line 646: AND rdb.last_updated_by = fnd.user_id

642: FROM hxc_rdb_pre_updated rdb,
643: fnd_user fnd,
644: per_people_f ppf -- Bug 12605349
645: WHERE rdb.ret_user_id = FND_GLOBAL.user_id
646: AND rdb.last_updated_by = fnd.user_id
647: AND fnd.employee_id = ppf.person_id
648: AND trunc(SYSDATE) BETWEEN ppf.effective_start_date -- Bug 14026118
649: AND ppf.effective_end_date;
650:

Line 1175: || 'from fnd_user '

1171:
1172: query1 := 'SELECT '
1173: || 'user_name INITIATED_BY, '
1174: || 'TO_CHAR(SYSDATE, ''' || l_icx_date_format || ''') RUN_DATE '
1175: || 'from fnd_user '
1176: || 'where user_id = fnd_global.user_id' ;
1177:
1178: qryCtx1 := dbms_xmlgen.newContext(query1);
1179: dbms_xmlgen.setRowTag(qryCtx1, NULL);