APPS.HXC_RDB_PRE_RETRIEVAL dependencies on HXC_RDB_PRE_UPDATED

Line 443: INTO hxc_rdb_pre_updated

439: IS
440:
441: BEGIN
442: INSERT
443: INTO hxc_rdb_pre_updated
444: (approval_status,
445: last_updated_by,
446: timecards,
447: ret_user_id)

Line 642: FROM hxc_rdb_pre_updated rdb,

638: CURSOR get_updated
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

Line 665: UPDATE hxc_rdb_pre_updated

661: rowtab LIMIT 500;
662: EXIT WHEN nametab.COUNT = 0;
663:
664: FORALL i IN nametab.FIRST..nametab.LAST
665: UPDATE hxc_rdb_pre_updated
666: SET last_updated_name = nametab(i),
667: resource_id = idtab(i)
668: WHERE rowid = CHARTOROWID(rowtab(i));
669:

Line 1103: DELETE FROM hxc_rdb_pre_updated

1099:
1100: DELETE FROM hxc_rdb_pre_hrs_pm
1101: WHERE ret_user_id = FND_GLOBAL.user_id;
1102:
1103: DELETE FROM hxc_rdb_pre_updated
1104: WHERE ret_user_id = FND_GLOBAL.user_id;
1105:
1106: DELETE FROM hxc_rdb_pre_skipped
1107: WHERE ret_user_id = FND_GLOBAL.user_id;