APPS.GHR_FORMULA_FUNCTIONS dependencies on GHR_SS_VIEWS_PKG

Line 1394: SELECT ghr_ss_views_pkg.get_ele_entry_value_ason_date (eef.element_entry_id, 'Enrollment', eef.effective_start_date) enrollment

1390:
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

Line 1441: SELECT ghr_ss_views_pkg.get_ele_entry_value_ason_date (eef.element_entry_id,

1437: v_temps_total_cost VARCHAR2(50);
1438:
1439:
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

Line 1625: (select ghr_ss_views_pkg.get_people_ei_id_ason_date(v_person_id,

1621: cursor c_get_agency_date is
1622: select to_date(pei_information14,'yyyy/mm/dd hh24:mi:ss') agency_date
1623: from ghr_people_extra_info_h_v
1624: where pa_history_id =
1625: (select ghr_ss_views_pkg.get_people_ei_id_ason_date(v_person_id,
1626: 'GHR_US_PER_BENEFIT_INFO',
1627: p_effective_date) from dual);
1628: Begin
1629: l_proc_name := g_package || '.get_agency_contrib_date';

Line 1663: (select ghr_ss_views_pkg.get_people_ei_id_ason_date(v_person_id,

1659: cursor c_get_emp_date is
1660: select to_date(pei_information15,'yyyy/mm/dd hh24:mi:ss') emp_date
1661: from ghr_people_extra_info_h_v
1662: where pa_history_id =
1663: (select ghr_ss_views_pkg.get_people_ei_id_ason_date(v_person_id,
1664: 'GHR_US_PER_BENEFIT_INFO',
1665: p_effective_date) from dual);
1666: Begin
1667: l_proc_name := g_package || 'get_emp_contrib_date';

Line 1702: (select ghr_ss_views_pkg.get_people_ei_id_ason_date(v_person_id,

1698: cursor c_get_coe_date is
1699: select to_date(pei_information10,'yyyy/mm/dd hh24:mi:ss') coe_date
1700: from ghr_people_extra_info_h_v
1701: where pa_history_id =
1702: (select ghr_ss_views_pkg.get_people_ei_id_ason_date(v_person_id,
1703: 'GHR_US_PER_BENEFIT_INFO',
1704: p_effective_date) from dual);
1705: Begin
1706: l_proc_name := g_package || 'get_coe_date';

Line 2102: SELECT ghr_ss_views_pkg.get_ele_entry_value_ason_date (eef.element_entry_id, 'FEGLI', eef.effective_start_date) enrollment

2098:
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