APPS.PAY_AE_IV_MIGRATE_PKG dependencies on PAY_INPUT_VALUES_F

Line 39: FROM pay_input_values_f piv

35:
36: /* Get input value id for input on SI and SI Adjustment element */
37: CURSOR csr_get_iv_id (l_element_type_id number, l_date date) IS
38: SELECT input_value_id
39: FROM pay_input_values_f piv
40: WHERE piv.element_type_id = l_element_type_id
41: AND piv.name = 'Exception Type'
42: AND piv.legislation_code = 'AE'
43: /*AND l_date between piv.effective_start_date and piv.effective_end_date*/;

Line 48: FROM pay_input_values_f piv

44:
45: /* Get input value id for Pay value for SI Element */
46: CURSOR csr_get_py_id (l_element_type_id number, l_date date) IS
47: SELECT input_value_id
48: FROM pay_input_values_f piv
49: WHERE piv.element_type_id = l_element_type_id
50: AND piv.name = 'Pay Value'
51: AND piv.legislation_code = 'AE'
52: /*AND l_date between piv.effective_start_date and piv.effective_end_date*/;