DBA Data[Home] [Help]

APPS.HXT_TIMECARD_API dependencies on HXT_TIMECARDS_F

Line 425: and pbh.batch_id in (select distinct batch_id from hxt_timecards_f

421:
422: cursor chk_original_batch_status is
423: select null from pay_batch_headers pbh
424: where pbh.batch_status='T'
425: and pbh.batch_id in (select distinct batch_id from hxt_timecards_f
426: where id=p_tim_id);
427:
428: cursor get_retro_total(p_accrual_plan_name VARCHAR2,p_batch_id number) is
429: SELECT nvl(sum(det.hours*(-1)*(net.add_or_subtract)),0)