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 383: l_name := ghr_pa_requests_pkg.get_full_name_unsecure(p_person_id,p_effective_date);

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

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

842: Raise Nothing_to_do;
843: End If;
844:
845: --get Full Name
846: l_name := ghr_pa_requests_pkg.get_full_name_unsecure(p_person_id,p_effective_date);
847: --dbms_output.put_line ('Full Name '||l_name);
848:
849: --get SSN
850: For get_ssn in c_get_ssn loop

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

1198: Raise Nothing_to_do;
1199: End If;
1200:
1201: --get Full Name
1202: l_name := ghr_pa_requests_pkg.get_full_name_unsecure(p_person_id,p_effective_date);
1203: --dbms_output.put_line ('Full Name '||l_name);
1204:
1205: --get SSN
1206: For get_ssn in c_get_ssn loop