APPS.HXT_TIME_DETAIL dependencies on PAY_ELEMENT_TYPES_F

Line 69: earning_category hxt_pay_element_types_f_ddf_v.hxt_earning_category%TYPE

65:
66: TYPE daily_explosion IS RECORD (
67: element_type_id NUMBER,
68: hours_to_pay NUMBER,
69: earning_category hxt_pay_element_types_f_ddf_v.hxt_earning_category%TYPE
70: );
71:
72: TYPE daily_explosion_table IS TABLE OF daily_explosion
73: INDEX BY BINARY_INTEGER;

Line 80: earning_category hxt_pay_element_types_f_ddf_v.hxt_earning_category%TYPE

76:
77: TYPE weekly_explosion IS RECORD (
78: element_type_id NUMBER,
79: hours_to_pay NUMBER,
80: earning_category hxt_pay_element_types_f_ddf_v.hxt_earning_category%TYPE
81: );
82:
83: TYPE weekly_explosion_table IS TABLE OF weekly_explosion
84: INDEX BY BINARY_INTEGER;

Line 101: earning_category hxt_pay_element_types_f_ddf_v.hxt_earning_category%TYPE

97:
98: TYPE daily_earn_category IS RECORD (
99: element_type_id NUMBER,
100: hours NUMBER,
101: earning_category hxt_pay_element_types_f_ddf_v.hxt_earning_category%TYPE
102: );
103:
104: TYPE daily_earn_category_table IS TABLE OF daily_earn_category
105: INDEX BY BINARY_INTEGER;

Line 112: earning_category hxt_pay_element_types_f_ddf_v.hxt_earning_category%TYPE

108:
109: TYPE weekly_earn_category IS RECORD (
110: element_type_id NUMBER,
111: hours NUMBER,
112: earning_category hxt_pay_element_types_f_ddf_v.hxt_earning_category%TYPE
113: );
114:
115: TYPE weekly_earn_category_table IS TABLE OF weekly_earn_category
116: INDEX BY BINARY_INTEGER;

Line 133: FROM hxt_pay_element_types_f_ddf_v eltv,

129: hrw.separate_check_flag, hrw.project_id, hrw.job_id,
130:
131: -- hrw.GROUP_ID,
132: hrw.earn_pol_id
133: FROM hxt_pay_element_types_f_ddf_v eltv,
134: pay_element_types_f elt,
135: hxt_det_hours_worked hrw
136: WHERE hrw.tim_id = p_tim_id
137: AND hrw.date_worked =

Line 134: pay_element_types_f elt,

130:
131: -- hrw.GROUP_ID,
132: hrw.earn_pol_id
133: FROM hxt_pay_element_types_f_ddf_v eltv,
134: pay_element_types_f elt,
135: hxt_det_hours_worked hrw
136: WHERE hrw.tim_id = p_tim_id
137: AND hrw.date_worked =
138: (SELECT MAX (hrw.date_worked)

Line 139: FROM hxt_pay_element_types_f_ddf_v eltv,

135: hxt_det_hours_worked hrw
136: WHERE hrw.tim_id = p_tim_id
137: AND hrw.date_worked =
138: (SELECT MAX (hrw.date_worked)
139: FROM hxt_pay_element_types_f_ddf_v eltv,
140: pay_element_types_f elt,
141: hxt_det_hours_worked hrw
142: WHERE hrw.tim_id = p_tim_id
143: AND NVL (hrw.hours, 0) > 0

Line 140: pay_element_types_f elt,

136: WHERE hrw.tim_id = p_tim_id
137: AND hrw.date_worked =
138: (SELECT MAX (hrw.date_worked)
139: FROM hxt_pay_element_types_f_ddf_v eltv,
140: pay_element_types_f elt,
141: hxt_det_hours_worked hrw
142: WHERE hrw.tim_id = p_tim_id
143: AND NVL (hrw.hours, 0) > 0
144: AND elt.element_type_id = hrw.element_type_id