APPS.HXT_TIM_COL_UTIL dependencies on PAY_ELEMENT_TYPES_F

Line 20: FROM hxt_pay_element_types_f_ddf_v eltv

16: IS
17: BEGIN
18: SELECT eltv.hxt_earning_category
19: INTO o_earning_cat
20: FROM hxt_pay_element_types_f_ddf_v eltv
21: WHERE eltv.element_type_id = i_element_type_id;
22: EXCEPTION
23: WHEN no_data_found THEN
24: o_earning_cat := NULL;

Line 156: hxt_pay_element_types_f_ddf_v eltv

152: SELECT MAX('Y') --5574629
153: INTO l_exists
154: FROM pay_element_links_f ell,
155: per_all_assignments_f asm,
156: hxt_pay_element_types_f_ddf_v eltv
157: WHERE asm.assignment_id = p_asg_id
158: AND p_date_worked BETWEEN asm.effective_start_date
159: AND asm.effective_end_date
160: AND ell.element_type_id = p_element_type_id

Line 211: FROM pay_element_types_f elt,

207: BEGIN
208: /* SQL query modified for Bug 2597231 */
209: SELECT elt.element_type_id
210: INTO o_element_type_id
211: FROM pay_element_types_f elt,
212: pay_element_types_f_tl eltt
213: WHERE eltt.element_name = i_element_name
214: AND eltt.language = userenv('LANG')
215: AND elt.element_type_id = eltt.element_type_id

Line 212: pay_element_types_f_tl eltt

208: /* SQL query modified for Bug 2597231 */
209: SELECT elt.element_type_id
210: INTO o_element_type_id
211: FROM pay_element_types_f elt,
212: pay_element_types_f_tl eltt
213: WHERE eltt.element_name = i_element_name
214: AND eltt.language = userenv('LANG')
215: AND elt.element_type_id = eltt.element_type_id
216: AND (elt.business_group_id = i_bg_id or elt.business_group_id is null)