777: and lookup_code = p_val; --
778:
779: cursor c_job is
780: select name 781: from per_jobs_vl job 782: where job_id = p_val;
783:
784: cursor c_bg is
785: select name
Line 1560: from per_jobs_vl job
1556: ; --
1557:
1558: cursor c_job is
1559: select job_id 1560: from per_jobs_vl job 1561: where name = p_meaning
1562: and business_group_id = p_business_group_id
1563: ;
1564: