DBA Data[Home] [Help]

APPS.HR_USER_DEDN_DRV dependencies on PAY_ELEMENT_TYPES_F

Line 59: FROM pay_element_types_f pet

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