DBA Data[Home] [Help]

APPS.GHR_BENEFITS_EIT dependencies on PQP_FEDHR_USPAY_INT_UTILS

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

235: AND elt.element_type_id = eef.element_type_id
236: AND eef.effective_start_date BETWEEN elt.effective_start_date AND
237: elt.effective_end_date
238: AND p_effective_date between eef.effective_start_date and eef.effective_end_date
239: AND upper(pqp_fedhr_uspay_int_utils.return_old_element_name(elt.element_name,
240: p_business_group_id,
241: p_effective_date))
242: IN ('HEALTH BENEFITS');
243: