[Home] [Help]
655: ,p_adjustment_only_flag => 'N'
656: ,p_closed_for_entry_flag => 'N'
657: ,p_indirect_only_flag => 'N'
658: ,p_multiply_value_flag => 'N'
659: ,p_standard_link_flag => 'N'
660: ,p_process_mode => NULL
661: ,p_payroll_formula_id => l_template_rec.uf_setup.formula_id
662: ,p_skip_formula => NULL
663: ,p_object_version_number => l_object_version_number
807: ,p_adjustment_only_flag => 'N'
808: ,p_closed_for_entry_flag => 'N'
809: ,p_indirect_only_flag => 'N'
810: ,p_multiply_value_flag => 'N'
811: ,p_standard_link_flag => 'N'
812: ,p_process_mode => NULL
813: ,p_payroll_formula_id => l_template_rec.ae_setup(i).uf_setup.formula_id
814: ,p_skip_formula => NULL
815: ,p_object_version_number => l_object_version_number
1689: --
1690: pay_in_utils.delete_balance_feeds
1691: (p_balance_name => 'Taxable Allowances for Projection'
1692: ,p_element_name => l_element.element_name
1693: ,p_input_value_name => 'Standard Taxable Value'
1694: ,p_effective_date => l_element.effective_start_date
1695: );
1696:
1697: pay_in_utils.delete_balance_feeds
1700: ,p_input_value_name => 'Taxable Value'
1701: ,p_effective_date => l_element.effective_start_date
1702: );
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
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:
1712: END IF ;
1713: