DBA Data[Home] [Help]

APPS.PAY_ZA_TAX_YEAR_START_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 73: FROM pay_element_types_f

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:

Line 226: FROM pay_element_types_f

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