APPS.GHR_FORMULA_FUNCTIONS dependencies on GHR_SS_VIEWS_PKG

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

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

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

1433: v_temps_total_cost VARCHAR2(50);
1434:
1435:
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

Line 1621: (select ghr_ss_views_pkg.get_people_ei_id_ason_date(v_person_id,

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

Line 1659: (select ghr_ss_views_pkg.get_people_ei_id_ason_date(v_person_id,

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

Line 1698: (select ghr_ss_views_pkg.get_people_ei_id_ason_date(v_person_id,

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