APPS.PAY_AE_IV_MIGRATE_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 90: FROM pay_element_entry_values_f peev

86:
87: /* Get the screen entry value for SI Adjustment Exception type value */
88: CURSOR csr_get_sia_entry_value (l_sia_exc_iv_id NUMBER, l_date DATE , l_sia_eeid NUMBER ) IS
89: SELECT peev.screen_entry_value
90: FROM pay_element_entry_values_f peev
91: WHERE peev.element_entry_id = l_sia_eeid
92: AND peev.input_value_id = l_sia_exc_iv_id
93: AND l_date BETWEEN peev.effective_start_date AND peev.effective_end_date;
94:

Line 98: FROM pay_element_entry_values_f peev

94:
95: /* Get the screen entry value for SI Elements Exception type value for current date */
96: CURSOR csr_get_si_entry_value (l_si_exc_iv_id NUMBER, l_date DATE , l_si_eeid NUMBER ) IS
97: SELECT peev.screen_entry_value
98: FROM pay_element_entry_values_f peev
99: WHERE peev.element_entry_id = l_si_eeid
100: AND peev.input_value_id = l_si_exc_iv_id
101: AND l_date BETWEEN peev.effective_start_date AND peev.effective_end_date;
102:

Line 106: FROM PAY_ELEMENT_ENTRY_VALUES_F

102:
103: /* Check if Exception type exists on SI element */
104: CURSOR csr_check_exc_on_si (L_SI_EE NUMBER ,l_si_exc_id NUMBER) IS
105: SELECT element_entry_value_id
106: FROM PAY_ELEMENT_ENTRY_VALUES_F
107: WHERE ELEMENT_ENTRY_ID = L_SI_EE
108: AND INPUT_VALUE_ID = l_si_exc_id;
109:
110: l_status NUMBER;

Line 265: INSERT INTO PAY_ELEMENT_ENTRY_VALUES_F

261:
262:
263: /* Insert an entry value for Exception type on SI element */
264:
265: INSERT INTO PAY_ELEMENT_ENTRY_VALUES_F
266: ( ELEMENT_ENTRY_VALUE_ID
267: , EFFECTIVE_START_DATE
268: , EFFECTIVE_END_DATE
269: , INPUT_VALUE_ID