DBA Data[Home] [Help]

APPS.HXT_TIMECARD_API dependencies on PAY_BATCH_HEADERS

Line 409: select max(batch_id) from pay_batch_headers pbh

405: AND sm.tim_id = p_tim_id;
406:
407:
408: cursor get_max_retro_batch is
409: select max(batch_id) from pay_batch_headers pbh
410: where pbh.batch_status='T'
411: and pbh.batch_id in (select distinct retro_batch_id from hxt_det_hours_worked_f
412: where tim_id=p_tim_id);
413:

Line 416: select batch_id from pay_batch_headers pbh

412: where tim_id=p_tim_id);
413:
414:
415: cursor chk_retro_batch_status is
416: select batch_id from pay_batch_headers pbh
417: where pbh.batch_status='T'
418: and pbh.batch_id in (select distinct retro_batch_id from hxt_det_hours_worked_f
419: where tim_id=p_tim_id);
420:

Line 423: select null from pay_batch_headers pbh

419: where tim_id=p_tim_id);
420:
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: