APPS.PAY_IE_MEDICAL_ADJUST dependencies on PAY_ELEMENT_TYPES_F

Line 20: FROM pay_element_types_f

16:
17: --
18: CURSOR element_csr IS
19: SELECT element_type_id
20: FROM pay_element_types_f
21: WHERE element_name = 'Setup BIK Medical Insurance'
22: -- AND nvl(business_group_id, p_bg_id) = p_bg_id
23: AND legislation_code = 'IE'
24: AND p_eff_date BETWEEN effective_start_date AND effective_end_date;

Line 189: from pay_element_types_f

185:
186: -- Cursor to get element_type_id
187: cursor csr_get_ele_id IS
188: select distinct element_type_id
189: from pay_element_types_f
190: where element_name = 'IE BIK Other Reportable Item Details'
191: and legislation_code = 'IE';
192:
193: -- Cursor to get input_val_id