APPS.PAY_IN_ELEMENT_TEMPLATE_PKG dependencies on PAY_INPUT_VALUES_F

Line 1707: DELETE FROM pay_input_values_f

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

Line 1876: UPDATE pay_input_values_f

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