APPS.HXT_RETRO_PROCESS dependencies on HXT_DET_HOURS_WORKED_F_AR

Line 54: FROM hxt_det_hours_worked_f_ar ar

50: AND tbs.status in ('VE','H','VT','VV','VW') -- RETROPAY
51: AND tim.id = det.tim_id
52: AND pbh.batch_id = tbs.batch_id
53: AND NOT EXISTS( SELECT 1
54: FROM hxt_det_hours_worked_f_ar ar
55: WHERE ar.retro_batch_id = pbh.batch_id)
56: AND pbh.business_group_id = p_bus_group_id;
57:
58: batch_rec cur_batch%ROWTYPE;