DBA Data[Home] [Help]

APPS.GHR_SF52_UPDATE dependencies on PAY_ELEMENT_TYPES_F

Line 473: pay_element_types_f elt

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