APPS.GHR_FORMULA_FUNCTIONS dependencies on PAY_ELEMENT_TYPES_F

Line 56: from pay_element_types_f elt

52: --
53: Cursor c_get_elements
54: is
55: select element_name
56: from pay_element_types_f elt
57: where element_type_id in
58: (select element_type_id
59: from pay_element_links_f
60: where element_link_id in

Line 81: from pay_element_types_f elt

77: --
78: Cursor c_get_elements_health
79: is
80: select element_name
81: from pay_element_types_f elt
82: where element_type_id in
83: (select element_type_id
84: from pay_element_links_f
85: where element_link_id in

Line 1392: pay_element_types_f elt

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
1396: elt.effective_end_date

Line 1441: pay_element_types_f elt

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
1445: elt.effective_end_date