APPS.GHR_FORMULA_FUNCTIONS dependencies on GHR_PEOPLE_EXTRA_INFO_H_V

Line 1623: from ghr_people_extra_info_h_v

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

Line 1661: from ghr_people_extra_info_h_v

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

Line 1700: from ghr_people_extra_info_h_v

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