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 1391: FROM pay_element_entries_f eef,

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

Line 1440: FROM pay_element_entries_f eef,

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