eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_RDB_PRE_RETRIEVAL dependencies on HXC_RDB_PRE_SKIPPED

Line 684: FROM hxc_rdb_pre_skipped rdb,

680: DECODE(ppf.current_npw_flag,'Y',
681: ppf.npw_number,
682: ppf.employee_number),
683: ROWIDTOCHAR(rdb.rowid)
684: FROM hxc_rdb_pre_skipped rdb,
685: per_people_f ppf -- Bug 12605349
686: WHERE trunc(SYSDATE) BETWEEN ppf.effective_start_date -- Bug 14026118
687: AND ppf.effective_end_date
688: AND rdb.resource_id = ppf.person_id

Line 704: UPDATE hxc_rdb_pre_skipped

700: rowtab LIMIT 500;
701: EXIT WHEN nametab.COUNT = 0;
702:
703: FORALL i IN nametab.FIRST..nametab.LAST
704: UPDATE hxc_rdb_pre_skipped
705: SET emp_name = nametab(i),
706: emp_no = notab(i)
707: WHERE rowid = chartorowid(rowtab(i));
708:

Line 843: INSERT INTO hxc_rdb_pre_skipped

839: ovntab,ludtab LIMIT 500;
840: EXIT WHEN restab.COUNT = 0;
841:
842: FORALL i IN restab.FIRST..restab.LAST
843: INSERT INTO hxc_rdb_pre_skipped
844: ( resource_id,
845: timecard_id,
846: approval_status,
847: start_time,

Line 976: INSERT INTO hxc_rdb_pre_skipped

972: ovntab,ludtab LIMIT 500;
973: EXIT WHEN restab.COUNT = 0;
974:
975: FORALL i IN restab.FIRST..restab.LAST
976: INSERT INTO hxc_rdb_pre_skipped
977: ( resource_id,
978: timecard_id,
979: approval_status,
980: start_time,

Line 1106: DELETE FROM hxc_rdb_pre_skipped

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;
1108:
1109: COMMIT;
1110: