APPS.GHR_PER_SUM dependencies on PER_PEOPLE_EXTRA_INFO

Line 39: l_per_ei_data per_people_extra_info%rowtype;

35: ,p_information28 IN OUT NOCOPY VARCHAR2
36: ,p_information29 IN OUT NOCOPY VARCHAR2
37: ,p_information30 IN OUT NOCOPY VARCHAR2) IS
38:
39: l_per_ei_data per_people_extra_info%rowtype;
40: BEGIN
41: ghr_history_fetch.fetch_peopleei(
42: p_person_id => p_person_id
43: ,p_information_type => p_information_type

Line 350: FROM per_people_extra_info pei

346: ) IS
347: CURSOR cur_pei IS
348: SELECT pei.pei_information1 date_from
349: ,pei.pei_information2 date_to
350: FROM per_people_extra_info pei
351: WHERE pei.person_extra_info_id = p_person_extra_info_id;
352:
353: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
354:

Line 385: FROM per_people_extra_info pei

381: RETURN BOOLEAN IS
382: --
383: CURSOR cur_pei IS
384: SELECT 1
385: FROM per_people_extra_info pei
386: WHERE pei.person_id = p_person_id
387: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
388: AND pei.person_extra_info_id <> NVL(p_person_extra_info_id,-999);
389: --