eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_FORMULA_FUNCTIONS dependencies on PQP_FEDHR_USPAY_INT_UTILS

Line 67: upper(pqp_fedhr_uspay_int_utils.return_new_element_name

63: where assignment_id = p_asg_id
64: and p_effective_date between effective_start_date and effective_end_date)
65: and p_effective_date between effective_start_date and effective_end_date)
66: and upper(element_name) =
67: upper(pqp_fedhr_uspay_int_utils.return_new_element_name
68: ('Health Benefits Pre tax',p_business_group_id,p_effective_date,NULL))
69: and p_effective_date between effective_start_date and effective_end_date
70: and (elt.business_group_id is null or elt.business_group_id= p_business_group_id );
71: --

Line 92: upper(pqp_fedhr_uspay_int_utils.return_new_element_name

88: where assignment_id = p_asg_id
89: and p_effective_date between effective_start_date and effective_end_date)
90: and p_effective_date between effective_start_date and effective_end_date)
91: and upper(element_name) =
92: upper(pqp_fedhr_uspay_int_utils.return_new_element_name
93: ('Health Benefits',p_business_group_id,p_effective_date,NULL))
94: and p_effective_date between effective_start_date and effective_end_date
95: and (elt.business_group_id is null or elt.business_group_id= p_business_group_id);
96: --

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

1394: AND elt.element_type_id = eef.element_type_id
1395: AND eef.effective_start_date BETWEEN elt.effective_start_date AND
1396: elt.effective_end_date
1397: and p_effective_date between eef.effective_start_date and eef.effective_end_date
1398: AND upper(pqp_fedhr_uspay_int_utils.return_old_element_name(elt.element_name,
1399: p_business_group_id,
1400: p_effective_date))
1401: IN ('HEALTH BENEFITS','HEALTH BENEFITS PRE TAX') ;
1402: v_curr_enrollment varchar2(10);

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

1444: AND eef.effective_start_date BETWEEN elt.effective_start_date AND
1445: elt.effective_end_date
1446: and (p_effective_date - 1) between eef.effective_start_date
1447: and eef.effective_end_date
1448: AND upper(pqp_fedhr_uspay_int_utils.return_old_element_name(elt.element_name,
1449: p_business_group_id,
1450: p_effective_date))
1451: IN ('HEALTH BENEFITS','HEALTH BENEFITS PRE TAX') ;
1452: Begin