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 PAY_ELEMENT_ENTRIES_F

Line 62: from pay_element_entries_f

58: (select element_type_id
59: from pay_element_links_f
60: where element_link_id in
61: (select element_link_id
62: from pay_element_entries_f
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) =

Line 87: from pay_element_entries_f

83: (select element_type_id
84: from pay_element_links_f
85: where element_link_id in
86: (select element_link_id
87: from pay_element_entries_f
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) =

Line 1395: FROM pay_element_entries_f eef,

1391: RETURN VARCHAR2 is
1392:
1393: cursor get_current_enrollment is
1394: SELECT ghr_ss_views_pkg.get_ele_entry_value_ason_date (eef.element_entry_id, 'Enrollment', eef.effective_start_date) enrollment
1395: FROM pay_element_entries_f eef,
1396: pay_element_types_f elt
1397: WHERE assignment_id = p_asg_id
1398: AND elt.element_type_id = eef.element_type_id
1399: AND eef.effective_start_date BETWEEN elt.effective_start_date AND

Line 1444: FROM pay_element_entries_f eef,

1440: cursor c_get_current_temps_total_cost is
1441: SELECT ghr_ss_views_pkg.get_ele_entry_value_ason_date (eef.element_entry_id,
1442: 'Temps Total Cost',
1443: p_effective_date - 1) temps_cost
1444: FROM pay_element_entries_f eef,
1445: pay_element_types_f elt
1446: WHERE assignment_id = p_asg_id
1447: AND elt.element_type_id = eef.element_type_id
1448: AND eef.effective_start_date BETWEEN elt.effective_start_date AND

Line 2103: FROM pay_element_entries_f eef,

2099: RETURN VARCHAR2 is
2100:
2101: cursor get_current_enrollment is
2102: SELECT ghr_ss_views_pkg.get_ele_entry_value_ason_date (eef.element_entry_id, 'FEGLI', eef.effective_start_date) enrollment
2103: FROM pay_element_entries_f eef,
2104: pay_element_types_f elt
2105: WHERE assignment_id = p_asg_id
2106: AND elt.element_type_id = eef.element_type_id
2107: AND eef.effective_start_date BETWEEN elt.effective_start_date AND