69:
70: -- Get the element_type_id for ZA_tax --
71: SELECT element_type_id
72: INTO l_element_type_id
73: FROM pay_element_types_f
74: WHERE element_name = 'ZA_Tax'
75: AND l_tax_year_end BETWEEN effective_start_date AND effective_end_date;
76:
77:
222:
223: -- Get the element_type_id for ZA_tax --
224: SELECT element_type_id
225: INTO l_element_type_id
226: FROM pay_element_types_f
227: WHERE element_name = 'ZA_Tax'
228: AND l_tax_year_end BETWEEN effective_start_date AND effective_end_date;
229:
230: -- Get the input_value_id's for Tax Status ,Tax Directive Number, Tax Directive Value