APPS.GHR_FORMULA_FUNCTIONS dependencies on GHR_PEOPLE_EXTRA_INFO_H_V

Line 1619: from ghr_people_extra_info_h_v

1615: and trunc(p_effective_date) between effective_start_date and effective_end_date;
1616:
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);

Line 1657: from ghr_people_extra_info_h_v

1653: and trunc(p_effective_date) between effective_start_date and effective_end_date;
1654:
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);

Line 1696: from ghr_people_extra_info_h_v

1692: and trunc(p_effective_date) between effective_start_date and effective_end_date;
1693:
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);