DBA Data[Home] [Help]

APPS.PAY_NL_LSS_FUNCTIONS dependencies on PAY_INPUT_VALUES_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';