DBA Data[Home] [Help]

APPS.GHR_FEHB_PLAN_DESIGN dependencies on PQP_FEDHR_USPAY_INT_UTILS

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

731: AND eef.effective_start_date BETWEEN elt.effective_start_date AND elt.effective_end_date
732: AND eef.effective_start_date BETWEEN asg.effective_start_date AND asg.effective_end_date
733: and eef.effective_end_date = hr_api.g_eot
734: and asg.business_group_id = p_business_group_id
735: AND upper(pqp_fedhr_uspay_int_utils.return_old_element_name(elt.element_name,
736: p_business_group_id,
737: eef.effective_start_date))
738: IN ('HEALTH BENEFITS'
739: -- ,'HEALTH BENEFITS PRE TAX'