APPS.HXT_TIMECARD_API dependencies on HXT_DET_HOURS_WORKED_F

Line 411: and pbh.batch_id in (select distinct retro_batch_id from hxt_det_hours_worked_f

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:
414:
415: cursor chk_retro_batch_status is

Line 418: and pbh.batch_id in (select distinct retro_batch_id from hxt_det_hours_worked_f

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:
421:
422: cursor chk_original_batch_status is

Line 435: ,hxt_det_hours_worked_f det

431: ,pay_element_types_f elt
432: ,PAY_ACCRUAL_PLANS pap
433: ,PAY_NET_CALCULATION_RULES net
434: ,PAY_INPUT_VALUES_F piv
435: ,hxt_det_hours_worked_f det
436: ,per_assignments_f asm
437: WHERE elt.element_type_id = eltv.element_type_id
438: AND eltv.hxt_earning_category = 'ABS'
439: AND net.ACCRUAL_PLAN_ID = pap.ACCRUAL_PLAN_ID

Line 460: ,hxt_det_hours_worked_f det

456: ,pay_element_types_f elt
457: ,PAY_ACCRUAL_PLANS pap
458: ,PAY_NET_CALCULATION_RULES net
459: ,PAY_INPUT_VALUES_F piv
460: ,hxt_det_hours_worked_f det
461: ,per_assignments_f asm
462: WHERE elt.element_type_id = eltv.element_type_id
463: AND eltv.hxt_earning_category = 'ABS'
464: AND net.ACCRUAL_PLAN_ID = pap.ACCRUAL_PLAN_ID

Line 479: FROM hxt_det_hours_worked_f det,

475: and det.retro_batch_id is null;
476:
477: cursor get_tc_dates(p_tim_id NUMBER) is
478: SELECT date_worked
479: FROM hxt_det_hours_worked_f det,
480: hxt_pay_element_types_f_ddf_v eltv
481: WHERE det.tim_id=p_tim_id
482: AND eltv.hxt_earning_category = 'ABS'
483: AND det.element_type_id = eltv.element_type_id

Line 499: l_date_worked hxt_det_hours_worked_f.date_worked%TYPE;

495: v_otm_error VARCHAR2(1200);
496: v_oracle_error VARCHAR2(512);
497: l_batch_id NUMBER;
498: l_old_total NUMBER;
499: l_date_worked hxt_det_hours_worked_f.date_worked%TYPE;
500: l_flag_acc_exceeded NUMBER(1);
501:
502: --no_accrual_plan EXCEPTION;
503: no_summary_rows EXCEPTION;