DBA Data[Home] [Help]

APPS.HR_GENERAL dependencies on PER_JOBS

Line 1014: from per_jobs_vl

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

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

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