APPS.GHR_GENERAL dependencies on GHR_PA_REQUESTS_PKG

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