[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
1690: --
1691: pay_in_utils.delete_balance_feeds
1692: (p_balance_name => 'Taxable Allowances for Projection'
1693: ,p_element_name => l_element.element_name
1694: ,p_input_value_name => 'Standard Taxable Value'
1695: ,p_effective_date => l_element.effective_start_date
1696: );
1697:
1698: pay_in_utils.delete_balance_feeds
1701: ,p_input_value_name => 'Taxable Value'
1702: ,p_effective_date => l_element.effective_start_date
1703: );
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
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:
1713: END IF ;
1714: