APPS.GHR_UTILITY dependencies on PER_PEOPLE_F

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

850: RETURN(l_noa_code);
851: END;
852:
853: procedure process_nfc_auth_date(
854: --p_person_id in per_people_f.person_id%type,
855: p_effective_date in ghr_pa_requests.effective_date%type,
856: p_pa_request_id in ghr_pa_requests.pa_request_id%type)
857: is
858: cursor get_next_auth_date is

Line 884: p_person_id in per_people_f.person_id%type,

880: end loop;
881: end;
882:
883: function get_nfc_prev_noa(
884: p_person_id in per_people_f.person_id%type,
885: p_pa_notification_id in ghr_pa_requests.pa_notification_id%type,
886: p_effective_date in ghr_pa_requests.effective_date%type)
887: RETURN VARCHAR2
888: IS

Line 915: p_person_id in per_people_f.person_id%type,

911: RETURN NULL;
912: END;
913:
914: procedure get_nfc_auth_codes(
915: p_person_id in per_people_f.person_id%type,
916: p_pa_notification_id in ghr_pa_requests.pa_notification_id%type,
917: p_effective_date in ghr_pa_requests.effective_date%type,
918: p_first_auth_code out nocopy ghr_pa_requests.FIRST_ACTION_LA_CODE1%type,
919: p_second_auth_code out nocopy ghr_pa_requests.FIRST_ACTION_LA_CODE1%type)

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

956: RETURN NUMBER
957: IS
958: cursor c_ex_emp is
959: select 'X'
960: from per_people_f per, per_person_types ppt, ghr_pa_requests par
961: where par.pa_request_id = p_pa_request_id
962: and per.person_id = par.person_id
963: and ppt.person_type_id = per.person_type_id
964: and ppt.system_person_type = 'EX_EMP'