DBA Data[Home] [Help]

APPS.GHR_SF52_PRE_UPDATE dependencies on PQP_FEDHR_USPAY_INT_UTILS

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

2694: WHERE assignment_id = p_pa_request_rec.employee_assignment_id
2695: AND elt.element_type_id = eef.element_type_id
2696: AND eef.effective_start_date BETWEEN elt.effective_start_date AND elt.effective_end_date
2697: AND p_pa_request_rec.effective_date between eef.effective_start_date and eef.effective_end_date
2698: AND upper(pqp_fedhr_uspay_int_utils.return_old_element_name(elt.element_name,
2699: p_business_group_id,
2700: p_pa_request_rec.effective_date)) IN ('HEALTH BENEFITS','HEALTH BENEFITS PRE TAX');
2701:
2702: