APPS.PAY_NL_LSS_FUNCTIONS dependencies on PAY_ELEMENT_TYPES_F

Line 315: FROM pay_element_types_f pet, pay_input_values_f piv

311: AND business_group_id = p_business_group;
312:
313: CURSOR csr_cur_yr_col6 IS
314: SELECT pet.element_type_id, piv.name
315: FROM pay_element_types_f pet, pay_input_values_f piv
316: WHERE pet.element_name = 'Life Savings Scheme General Information'
317: AND pet.element_type_id = piv.element_type_id
318: AND piv.legislation_code = 'NL'
319: AND upper(piv.name) = 'CURRENT YEAR COLUMN 6';

Line 523: FROM pay_element_types_f

519: l_element_type_id NUMBER;
520:
521: CURSOR c_ele_cur IS
522: SELECT element_type_id
523: FROM pay_element_types_f
524: WHERE element_name = 'Life Savings Scheme General Information'
525: AND legislation_code = 'NL'
526: AND p_date_earned BETWEEN effective_start_date AND
527: effective_end_date;