DBA Data[Home] [Help]

APPS.HR_USER_DEDN_DRV dependencies on PAY_INPUT_VALUES_F

Line 59: ,pay_input_values_f piv

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
63: AND pet.business_group_id +0 = p_bg_id