APPS.HR_BEN_BENEFIT_CONTRIBUTIONS dependencies on PAY_ELEMENT_TYPES_F

Line 191: FROM pay_element_types_f et

187: -- check to see if future changes exist to benefit element
188: --
189: CURSOR get_element IS
190: SELECT 'Y'
191: FROM pay_element_types_f et
192: WHERE et.element_type_id = p_element_type_id
193: AND et.effective_end_date = to_date('31-12-4712','DD-MM-YYYY')
194: AND p_session_date BETWEEN
195: et.effective_start_date and et.effective_end_date;

Line 204: pay_element_types_f et

200: SELECT
201: iv_cov.input_value_id iv_cov
202: FROM
203: pay_input_values_f iv_cov,
204: pay_element_types_f et
205: WHERE
206: et.element_type_id = p_element_type_id
207: AND
208: iv_cov.element_type_id = et.element_type_id AND