DBA Data[Home] [Help]

APPS.GHR_GENERAL dependencies on PQP_FEDHR_USPAY_INT_UTILS

Line 346: AND upper(pqp_fedhr_uspay_int_utils.return_old_element_name(elt_new.element_name,

342: and elt_new.element_type_id = eef_new.element_type_id
343: AND eef_new.effective_start_date BETWEEN elt_new.effective_start_date AND elt_new.effective_end_date
344: and eef_new.effective_start_date = trunc(p_effective_date)
345: and eef_new.effective_end_date = hr_api.g_eot
346: AND upper(pqp_fedhr_uspay_int_utils.return_old_element_name(elt_new.element_name,
347: p_business_group_id,
348: eef_new.effective_start_date))
349: IN ('HEALTH BENEFITS PRE TAX'
350: );