APPS.GHR_GENERAL dependencies on GHR_PA_REQUESTS_PKG

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