DBA Data[Home] [Help]

APPS.HXT_RETRO_VAL dependencies on HXT_TIMECARDS_X

Line 31: FROM hxt_timecards_x tim, -- commenting out. using sysdate view, now. RTF

27: WHERE ROWID IN
28: (
29: /* batch_sum_amounts rows with override Amount<>0, Hours=0*/
30: SELECT hrw.ROWID
31: FROM hxt_timecards_x tim, -- commenting out. using sysdate view, now. RTF
32: hxt_det_hours_worked_x hrw -- commenting out. using sysdate view, now. RTF
33:
34: -- begin OHMPERFFIX - performance fix done by Bryan Crissman and Damon
35: -- Grube at OHM. the Where rowid in () or rowid in ()

Line 67: FROM hxt_timecards_x htx

63: CURSOR csr_additional_info (p_tim_id hxt_timecards_f.id%TYPE)
64: IS
65: SELECT DISTINCT htx.for_person_id, htx.time_period_id,
66: htx.approv_person_id, htx.auto_gen_flag
67: FROM hxt_timecards_x htx
68: WHERE htx.id = p_tim_id;
69:
70: rec_additional_info csr_additional_info%ROWTYPE;
71: BEGIN