DBA Data[Home] [Help]

APPS.GHR_CREATE_PTNL_LIFE_EVENTS dependencies on PQP_FEDHR_USPAY_INT_UTILS

Line 96: decode(upper(pqp_fedhr_uspay_int_utils.return_old_element_name(elt.element_name,

92: Cursor c_get_current_enrollment is
93: SELECT ghr_ss_views_pkg.get_ele_entry_value_ason_date (eef.element_entry_id,
94: 'Enrollment',
95: p_pa_request_rec.effective_date) enrollment,
96: decode(upper(pqp_fedhr_uspay_int_utils.return_old_element_name(elt.element_name,
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,

Line 108: AND upper(pqp_fedhr_uspay_int_utils.return_old_element_name(elt.element_name,

104: AND eef.effective_start_date BETWEEN elt.effective_start_date AND
105: elt.effective_end_date
106: and p_pa_request_rec.effective_date between eef.effective_start_date
107: and eef.effective_end_date
108: AND upper(pqp_fedhr_uspay_int_utils.return_old_element_name(elt.element_name,
109: l_business_group_id,
110: p_pa_request_rec.effective_date))
111: IN ('HEALTH BENEFITS','HEALTH BENEFITS PRE TAX') ;
112: