APPS.PAY_IN_ELEMENT_TEMPLATE_PKG dependencies on PAY_INPUT_VALUES_F

Line 1708: DELETE FROM pay_input_values_f

1704: --
1705: -- Delete input values : Allowance Amount, Taxable Value, Standard Taxable Value
1706: --
1707:
1708: DELETE FROM pay_input_values_f
1709: WHERE element_type_id = l_element.element_type_id
1710: AND NAME IN ('Allowance Amount','Taxable Value','Standard Taxable Value')
1711: AND l_element.effective_start_date BETWEEN effective_start_date AND effective_end_date;
1712:

Line 1877: UPDATE pay_input_values_f

1873: pay_in_utils.trace('Input Value Id ',TO_CHAR(l_input_value_id));
1874: pay_in_utils.trace('Flex Value Set ID ',TO_CHAR(l_flx_val_set_id));
1875: END IF;
1876:
1877: UPDATE pay_input_values_f
1878: SET value_set_id = l_flx_val_set_id
1879: WHERE input_value_id = l_input_value_id
1880: AND l_element.effective_start_date BETWEEN effective_start_date AND effective_end_date;
1881: