APPS.HXT_HXT007A_XMLP_PKG dependencies on HXT_DET_HOURS_WORKED_F

Line 59: hxt_det_hours_worked_f det,

55: CURSOR details_hours_cur IS
56: SELECT SUM(det.hours)
57: FROM pay_element_types_f elt,
58: hxt_pay_element_types_f_ddf_v eltv,
59: hxt_det_hours_worked_f det,
60: hxt_timecards_f tim
61: WHERE det.element_type_id = elt.element_type_id
62: AND det.date_worked BETWEEN elt.effective_start_date AND elt.effective_end_date
63: AND elt.element_type_id = eltv.element_type_id

Line 70: l_details_hours hxt_det_hours_worked_f.hours%TYPE := NULL;

66: AND det.retro_batch_id IS NULL
67: AND det.tim_id = tim.id
68: AND tim.batch_id = P_BATCH_ID;
69:
70: l_details_hours hxt_det_hours_worked_f.hours%TYPE := NULL;
71:
72: begin
73: OPEN details_hours_cur;
74: FETCH details_hours_cur INTO l_details_hours;

Line 137: l_hours HXT_DET_HOURS_WORKED_F.HOURS%TYPE := 0;

133: lookup14 PAY_INPUT_VALUES_F.LOOKUP_TYPE%TYPE := NULL;
134: lookup15 PAY_INPUT_VALUES_F.LOOKUP_TYPE%TYPE := NULL;
135: l_meaning HR_LOOKUPS.MEANING%TYPE;
136: l_value PAY_BATCH_LINES.VALUE_1%TYPE;
137: l_hours HXT_DET_HOURS_WORKED_F.HOURS%TYPE := 0;
138: l_amount VARCHAR2(80) := NULL;
139: l_dummy NUMBER;
140:
141: CURSOR hours_value(p_meaning VARCHAR2, p_date DATE) IS