APPS.GHR_GENERAL dependencies on GHR_PA_REQUESTS

Line 75: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;

71:
72: l_person_id number;
73: l_effective_date date := sysdate;
74: l_groupbox_name ghr_groupboxes.name%type;
75: l_personnel_office_id ghr_pa_requests.personnel_office_id%type;
76: l_gbx_user_id ghr_pois.person_id%type;
77: l_receiver_name ghr_groupboxes.name%type;
78:
79:

Line 387: l_name := ghr_pa_requests_pkg.get_full_name_unsecure(p_person_id,p_effective_date);

383: Raise Nothing_to_do;
384: End If;
385:
386: --get Full Name
387: l_name := ghr_pa_requests_pkg.get_full_name_unsecure(p_person_id,p_effective_date);
388:
389: --get SSN
390: For get_ssn in c_get_ssn loop
391: l_ssn := get_ssn.national_identifier;

Line 862: l_name := ghr_pa_requests_pkg.get_full_name_unsecure(p_person_id,p_effective_date);

858: Raise Nothing_to_do;
859: End If;
860:
861: --get Full Name
862: l_name := ghr_pa_requests_pkg.get_full_name_unsecure(p_person_id,p_effective_date);
863: --dbms_output.put_line ('Full Name '||l_name);
864:
865: --get SSN
866: For get_ssn in c_get_ssn loop

Line 1230: l_name := ghr_pa_requests_pkg.get_full_name_unsecure(p_person_id,p_effective_date);

1226: Raise Nothing_to_do;
1227: End If;
1228:
1229: --get Full Name
1230: l_name := ghr_pa_requests_pkg.get_full_name_unsecure(p_person_id,p_effective_date);
1231: --dbms_output.put_line ('Full Name '||l_name);
1232:
1233: --get SSN
1234: For get_ssn in c_get_ssn loop