DBA Data[Home] [Help]

APPS.GHR_SF52_UPDATE dependencies on PQP_FEDHR_USPAY_INT_UTILS

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

475: AND elt.element_type_id = eef.element_type_id
476: AND eef.effective_start_date BETWEEN elt.effective_start_date AND
477: elt.effective_end_date
478: AND p_effective_date between eef.effective_start_date and eef.effective_end_date
479: AND upper(pqp_fedhr_uspay_int_utils.return_old_element_name(elt.element_name,
480: p_business_group_id,
481: p_effective_date))
482: IN ('HEALTH BENEFITS','HEALTH BENEFITS PRE TAX');
483: