APPS.HXT_BATCH_VAL dependencies on HXT_DET_HOURS_WORKED_F

Line 1069: p_day IN hxt_det_hours_worked_f.date_worked%TYPE,

1065: END get_holiday_info;
1066:
1067: FUNCTION sum_unexploded_hours (
1068: p_tim_id IN hxt_timecards.id%TYPE,
1069: p_day IN hxt_det_hours_worked_f.date_worked%TYPE,
1070: p_hours_type IN hxt_det_hours_worked_f.hours%TYPE DEFAULT NULL
1071: )
1072: RETURN NUMBER
1073: AS

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

1066:
1067: FUNCTION sum_unexploded_hours (
1068: p_tim_id IN hxt_timecards.id%TYPE,
1069: p_day IN hxt_det_hours_worked_f.date_worked%TYPE,
1070: p_hours_type IN hxt_det_hours_worked_f.hours%TYPE DEFAULT NULL
1071: )
1072: RETURN NUMBER
1073: AS
1074: l_proc VARCHAR2 (72) ;

Line 1082: p_day hxt_det_hours_worked_f.date_worked%TYPE,

1078: -- .If no hours type is passed in we sum all hours, with our without
1079: -- hours override
1080: CURSOR csr_sum_hours (
1081: p_tim_id IN hxt_timecards.id%TYPE,
1082: p_day hxt_det_hours_worked_f.date_worked%TYPE,
1083: p_hours_type hxt_det_hours_worked_f.hours%TYPE
1084: )
1085: IS
1086: SELECT SUM (hshwx.hours)

Line 1083: p_hours_type hxt_det_hours_worked_f.hours%TYPE

1079: -- hours override
1080: CURSOR csr_sum_hours (
1081: p_tim_id IN hxt_timecards.id%TYPE,
1082: p_day hxt_det_hours_worked_f.date_worked%TYPE,
1083: p_hours_type hxt_det_hours_worked_f.hours%TYPE
1084: )
1085: IS
1086: SELECT SUM (hshwx.hours)
1087: FROM hxt_sum_hours_worked_x hshwx

Line 1440: p_date_worked hxt_det_hours_worked_f.date_worked%TYPE

1436: l_proc VARCHAR2 (72) ;
1437:
1438: CURSOR csr_det_hours (
1439: p_tim_id hxt_timecards.id%TYPE,
1440: p_date_worked hxt_det_hours_worked_f.date_worked%TYPE
1441: )
1442: IS
1443: SELECT SUM (hdhwx.hours) hours, hdhwx.element_type_id,
1444: haeif.earning_category