DBA Data[Home] [Help]

APPS.GHR_GENERAL dependencies on PQP_FEDHR_USPAY_INT_UTILS

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

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