APPS.GHR_SF52_UPDATE dependencies on PAY_ELEMENT_ENTRIES_F

Line 476: FROM pay_element_entries_f eef,

472: is
473: SELECT ghr_ss_views_pkg.get_ele_entry_value_ason_date (eef.element_entry_id, 'Enrollment', eef.effective_start_date) enrollment,
474: eef.element_entry_id ,
475: eef.object_version_number
476: FROM pay_element_entries_f eef,
477: pay_element_types_f elt
478: WHERE assignment_id = p_asg_id
479: AND elt.element_type_id = eef.element_type_id
480: AND eef.effective_start_date BETWEEN elt.effective_start_date AND

Line 490: l_object_version_number pay_element_entries_f.object_version_number%type;

486: IN ('HEALTH BENEFITS','HEALTH BENEFITS PRE TAX');
487:
488:
489:
490: l_object_version_number pay_element_entries_f.object_version_number%type;
491: l_effective_start_date date;
492: l_effective_end_date date;
493: l_delete_warning boolean;
494: l_exists BOOLEAN := FALSE;