APPS.GHR_BENEFITS_EIT dependencies on PAY_ELEMENT_ENTRIES_F

Line 232: FROM pay_element_entries_f eef,

228: is
229: SELECT ghr_ss_views_pkg.get_ele_entry_value_ason_date (eef.element_entry_id, 'Enrollment', eef.effective_start_date) enrollment,
230: eef.element_entry_id ,
231: eef.object_version_number
232: FROM pay_element_entries_f eef,
233: pay_element_types_f elt
234: WHERE assignment_id = p_asg_id
235: AND elt.element_type_id = eef.element_type_id
236: AND eef.effective_start_date BETWEEN elt.effective_start_date AND

Line 267: l_object_version_number pay_element_entries_f.object_version_number%type;

263: and p_effective_date between asg.effective_start_date
264: and asg.effective_end_date;
265:
266:
267: l_object_version_number pay_element_entries_f.object_version_number%type;
268: l_effective_start_date date;
269: l_effective_end_date date;
270: l_exp_date date;
271: l_delete_warning boolean;