APPS.HR_GENERAL dependencies on PER_JOBS

Line 1012: from per_jobs_vl

1008: p_job_id number) return varchar2 is
1009: --
1010: cursor csr_lookup is
1011: select name
1012: from per_jobs_vl
1013: where job_id = p_job_id;
1014: --
1015: v_meaning per_jobs.name%TYPE := null;
1016: --

Line 1015: v_meaning per_jobs.name%TYPE := null;

1011: select name
1012: from per_jobs_vl
1013: where job_id = p_job_id;
1014: --
1015: v_meaning per_jobs.name%TYPE := null;
1016: --
1017: begin
1018: --
1019: -- Only open the cursor if the parameter is going to retrieve anything