DBA Data[Home] [Help]

APPS.GHR_SF52_UPDATE dependencies on PQP_FEDHR_USPAY_INT_UTILS

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

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