DBA Data[Home] [Help]

APPS.HR_USER_DEDN_DRV dependencies on PAY_ELEMENT_TYPES_F

Line 58: FROM pay_element_types_f pet

54: , p_bg_id NUMBER
55: , p_eff_start_date DATE) IS
56: SELECT piv.input_value_id
57: ,piv.element_type_id
58: FROM pay_element_types_f pet
59: ,pay_input_values_f piv
60: WHERE pet.element_name = p_ele_name
61: AND pet.element_type_id = piv.element_type_id
62: AND piv.name = p_inp_val_name