DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on PER_JOBS_VL

Line 2232: from per_jobs_vl job

2228: -- pabodla : mapping data
2229: --
2230: cursor c_get_mapping_name3(p_id in number,p_date in date) is
2231: select job.name dsp_name
2232: from per_jobs_vl job
2233: where job.business_group_id = p_business_group_id
2234: and job.job_id = p_id
2235: and p_date between date_from and nvl(date_to,p_date);
2236:

Line 3444: from per_jobs_vl

3440:
3441: --
3442: cursor c_get_mapping_name14(p_id in number, p_id1 in number) is
3443: select name
3444: from per_jobs_vl
3445: where business_group_id = p_business_group_id
3446: and job_id = p_id
3447: and job_group_id = p_id1;
3448: