APPS.GHR_UTILITY dependencies on PER_PEOPLE_F

Line 871: --p_person_id in per_people_f.person_id%type,

867: RETURN(l_noa_code);
868: END;
869:
870: procedure process_nfc_auth_date(
871: --p_person_id in per_people_f.person_id%type,
872: p_effective_date in ghr_pa_requests.effective_date%type,
873: p_pa_request_id in ghr_pa_requests.pa_request_id%type)
874: is
875: cursor get_next_auth_date is

Line 901: p_person_id in per_people_f.person_id%type,

897: end loop;
898: end;
899:
900: function get_nfc_prev_noa(
901: p_person_id in per_people_f.person_id%type,
902: p_pa_notification_id in ghr_pa_requests.pa_notification_id%type,
903: p_effective_date in ghr_pa_requests.effective_date%type)
904: RETURN VARCHAR2
905: IS

Line 932: p_person_id in per_people_f.person_id%type,

928: RETURN NULL;
929: END;
930:
931: procedure get_nfc_auth_codes(
932: p_person_id in per_people_f.person_id%type,
933: p_pa_notification_id in ghr_pa_requests.pa_notification_id%type,
934: p_effective_date in ghr_pa_requests.effective_date%type,
935: p_first_auth_code out nocopy ghr_pa_requests.FIRST_ACTION_LA_CODE1%type,
936: p_second_auth_code out nocopy ghr_pa_requests.FIRST_ACTION_LA_CODE1%type)

Line 977: from per_people_f per, per_person_types ppt, ghr_pa_requests par

973: RETURN NUMBER
974: IS
975: cursor c_ex_emp is
976: select 'X'
977: from per_people_f per, per_person_types ppt, ghr_pa_requests par
978: where par.pa_request_id = p_pa_request_id
979: and per.person_id = par.person_id
980: and ppt.person_type_id = per.person_type_id
981: and ppt.system_person_type = 'EX_EMP'