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 1396: pay_element_types_f elt

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

Line 1445: pay_element_types_f elt

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

Line 2104: pay_element_types_f elt

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