APPS.GHR_CREATE_PTNL_LIFE_EVENTS dependencies on PAY_ELEMENT_TYPES_F

Line 101: pay_element_types_f elt

97: l_business_group_id,
98: p_pa_request_rec.effective_date)),'HEALTH BENEFITS','After','HEALTH BENEFITS PRE TAX','Pre') ben_type
99:
100: FROM pay_element_entries_f eef,
101: pay_element_types_f elt
102: WHERE assignment_id = p_pa_request_rec.employee_assignment_id
103: AND elt.element_type_id = eef.element_type_id
104: AND eef.effective_start_date BETWEEN elt.effective_start_date AND
105: elt.effective_end_date