DBA Data[Home] [Help]

APPS.GHR_SF52_PRE_UPDATE dependencies on PAY_ELEMENT_ENTRIES_F

Line 2692: FROM pay_element_entries_f eef,

2688:
2689: cursor get_enrollment_option (p_business_group_id in NUMBER)
2690: is
2691: SELECT ghr_ss_views_pkg.get_ele_entry_value_ason_date (eef.element_entry_id, 'Enrollment', eef.effective_start_date) enrollment
2692: FROM pay_element_entries_f eef,
2693: pay_element_types_f elt
2694: WHERE assignment_id = p_pa_request_rec.employee_assignment_id
2695: AND elt.element_type_id = eef.element_type_id
2696: AND eef.effective_start_date BETWEEN elt.effective_start_date AND elt.effective_end_date