APPS.HXT_BATCH_VAL dependencies on HXT_DET_HOURS_WORKED_F

Line 1190: p_day IN hxt_det_hours_worked_f.date_worked%TYPE,

1186: END get_holiday_info;
1187:
1188: FUNCTION sum_unexploded_hours (
1189: p_tim_id IN hxt_timecards.id%TYPE,
1190: p_day IN hxt_det_hours_worked_f.date_worked%TYPE,
1191: p_hours_type IN hxt_det_hours_worked_f.hours%TYPE DEFAULT NULL
1192: )
1193: RETURN NUMBER
1194: AS

Line 1191: p_hours_type IN hxt_det_hours_worked_f.hours%TYPE DEFAULT NULL

1187:
1188: FUNCTION sum_unexploded_hours (
1189: p_tim_id IN hxt_timecards.id%TYPE,
1190: p_day IN hxt_det_hours_worked_f.date_worked%TYPE,
1191: p_hours_type IN hxt_det_hours_worked_f.hours%TYPE DEFAULT NULL
1192: )
1193: RETURN NUMBER
1194: AS
1195: l_proc VARCHAR2 (72) ;

Line 1203: p_day hxt_det_hours_worked_f.date_worked%TYPE,

1199: -- .If no hours type is passed in we sum all hours, with our without
1200: -- hours override
1201: CURSOR csr_sum_hours (
1202: p_tim_id IN hxt_timecards.id%TYPE,
1203: p_day hxt_det_hours_worked_f.date_worked%TYPE,
1204: p_hours_type hxt_det_hours_worked_f.hours%TYPE
1205: )
1206: IS
1207: SELECT SUM (hshwx.hours)

Line 1204: p_hours_type hxt_det_hours_worked_f.hours%TYPE

1200: -- hours override
1201: CURSOR csr_sum_hours (
1202: p_tim_id IN hxt_timecards.id%TYPE,
1203: p_day hxt_det_hours_worked_f.date_worked%TYPE,
1204: p_hours_type hxt_det_hours_worked_f.hours%TYPE
1205: )
1206: IS
1207: SELECT SUM (hshwx.hours)
1208: FROM hxt_sum_hours_worked_x hshwx

Line 1620: p_date_worked hxt_det_hours_worked_f.date_worked%TYPE

1616: l_proc VARCHAR2 (72) ;
1617:
1618: CURSOR csr_det_hours (
1619: p_tim_id hxt_timecards.id%TYPE,
1620: p_date_worked hxt_det_hours_worked_f.date_worked%TYPE
1621: )
1622: IS
1623: SELECT SUM (hdhwx.hours) hours, hdhwx.element_type_id,
1624: haeif.earning_category