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 1402: AND upper(pqp_fedhr_uspay_int_utils.return_old_element_name(elt.element_name,

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

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

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

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

2106: AND elt.element_type_id = eef.element_type_id
2107: AND eef.effective_start_date BETWEEN elt.effective_start_date AND
2108: elt.effective_end_date
2109: and p_effective_date between eef.effective_start_date and eef.effective_end_date
2110: AND upper(pqp_fedhr_uspay_int_utils.return_old_element_name(elt.element_name,
2111: p_business_group_id,
2112: p_effective_date))
2113: IN ('FEGLI AB') ;
2114: v_curr_enrollment varchar2(10);