APPS.HXT_TIME_DETAIL dependencies on PAY_ELEMENT_TYPES_F

Line 81: earning_category hxt_pay_element_types_f_ddf_v.hxt_earning_category%TYPE

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

Line 92: earning_category hxt_pay_element_types_f_ddf_v.hxt_earning_category%TYPE

88:
89: TYPE weekly_explosion IS RECORD (
90: element_type_id NUMBER,
91: hours_to_pay NUMBER,
92: earning_category hxt_pay_element_types_f_ddf_v.hxt_earning_category%TYPE
93: );
94:
95: TYPE weekly_explosion_table IS TABLE OF weekly_explosion
96: INDEX BY BINARY_INTEGER;

Line 113: earning_category hxt_pay_element_types_f_ddf_v.hxt_earning_category%TYPE

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

Line 124: earning_category hxt_pay_element_types_f_ddf_v.hxt_earning_category%TYPE

120:
121: TYPE weekly_earn_category IS RECORD (
122: element_type_id NUMBER,
123: hours NUMBER,
124: earning_category hxt_pay_element_types_f_ddf_v.hxt_earning_category%TYPE
125: );
126:
127: TYPE weekly_earn_category_table IS TABLE OF weekly_earn_category
128: INDEX BY BINARY_INTEGER;

Line 145: FROM hxt_pay_element_types_f_ddf_v eltv,

141: hrw.separate_check_flag, hrw.project_id, hrw.job_id,
142:
143: -- hrw.GROUP_ID,
144: hrw.earn_pol_id
145: FROM hxt_pay_element_types_f_ddf_v eltv,
146: pay_element_types_f elt,
147: hxt_det_hours_worked hrw
148: WHERE hrw.tim_id = p_tim_id
149: AND hrw.date_worked =

Line 146: pay_element_types_f elt,

142:
143: -- hrw.GROUP_ID,
144: hrw.earn_pol_id
145: FROM hxt_pay_element_types_f_ddf_v eltv,
146: pay_element_types_f elt,
147: hxt_det_hours_worked hrw
148: WHERE hrw.tim_id = p_tim_id
149: AND hrw.date_worked =
150: (SELECT MAX (hrw.date_worked)

Line 151: FROM hxt_pay_element_types_f_ddf_v eltv,

147: hxt_det_hours_worked hrw
148: WHERE hrw.tim_id = p_tim_id
149: AND hrw.date_worked =
150: (SELECT MAX (hrw.date_worked)
151: FROM hxt_pay_element_types_f_ddf_v eltv,
152: pay_element_types_f elt,
153: hxt_det_hours_worked hrw
154: WHERE hrw.tim_id = p_tim_id
155: AND NVL (hrw.hours, 0) > 0

Line 152: pay_element_types_f elt,

148: WHERE hrw.tim_id = p_tim_id
149: AND hrw.date_worked =
150: (SELECT MAX (hrw.date_worked)
151: FROM hxt_pay_element_types_f_ddf_v eltv,
152: pay_element_types_f elt,
153: hxt_det_hours_worked hrw
154: WHERE hrw.tim_id = p_tim_id
155: AND NVL (hrw.hours, 0) > 0
156: AND elt.element_type_id = hrw.element_type_id