724: and lookup_code = p_val; --
725:
726: cursor c_job is
727: select name 728: from per_jobs_vl job 729: where job_id = p_val;
730:
731: cursor c_bg is
732: select name
Line 1507: from per_jobs_vl job
1503: ; --
1504:
1505: cursor c_job is
1506: select job_id 1507: from per_jobs_vl job 1508: where name = p_meaning
1509: and business_group_id = p_business_group_id
1510: ;
1511: