APPS.PAY_ZA_TAX_YEAR_START_PKG dependencies on PAY_INPUT_VALUES_F

Line 81: FROM pay_input_values_f

77:
78: -- Get the input_value_id's for Tax Status ,Tax Directive Number, Tax Directive Value
79: SELECT input_value_id
80: INTO tax_status_id
81: FROM pay_input_values_f
82: WHERE element_type_id = l_element_type_id
83: AND name = 'Tax Status'
84: AND l_tax_year_end BETWEEN effective_start_date AND effective_end_date;
85:

Line 88: FROM pay_input_values_f

84: AND l_tax_year_end BETWEEN effective_start_date AND effective_end_date;
85:
86: SELECT input_value_id
87: INTO tax_directive_number_id
88: FROM pay_input_values_f
89: WHERE element_type_id = l_element_type_id
90: AND name = 'Tax Directive Number'
91: AND l_tax_year_end BETWEEN effective_start_date AND effective_end_date;
92:

Line 95: FROM pay_input_values_f

91: AND l_tax_year_end BETWEEN effective_start_date AND effective_end_date;
92:
93: SELECT input_value_id
94: INTO tax_directive_value_id
95: FROM pay_input_values_f
96: WHERE element_type_id = l_element_type_id
97: AND name = 'Tax Directive Value'
98: AND l_tax_year_end BETWEEN effective_start_date AND effective_end_date;
99:

Line 233: FROM pay_input_values_f

229:
230: -- Get the input_value_id's for Tax Status ,Tax Directive Number, Tax Directive Value
231: SELECT input_value_id
232: INTO tax_status_id
233: FROM pay_input_values_f
234: WHERE element_type_id = l_element_type_id
235: AND name = 'Tax Status'
236: AND l_tax_year_end BETWEEN effective_start_date AND effective_end_date;
237:

Line 240: FROM pay_input_values_f

236: AND l_tax_year_end BETWEEN effective_start_date AND effective_end_date;
237:
238: SELECT input_value_id
239: INTO tax_directive_number_id
240: FROM pay_input_values_f
241: WHERE element_type_id = l_element_type_id
242: AND name = 'Tax Directive Number'
243: AND l_tax_year_end BETWEEN effective_start_date AND effective_end_date;
244:

Line 247: FROM pay_input_values_f

243: AND l_tax_year_end BETWEEN effective_start_date AND effective_end_date;
244:
245: SELECT input_value_id
246: INTO tax_directive_value_id
247: FROM pay_input_values_f
248: WHERE element_type_id = l_element_type_id
249: AND name = 'Tax Directive Value'
250: AND l_tax_year_end BETWEEN effective_start_date AND effective_end_date;
251: