APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on PER_JOBS

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 2239: from per_jobs

2235: and p_date between date_from and nvl(date_to,p_date);
2236:
2237: cursor c_job_start_date(c_job_id number) is
2238: select date_from
2239: from per_jobs
2240: where job_id = c_job_id;
2241:
2242: l_job_start_date per_jobs.date_from%type;
2243: ---------------------------------------------------------------

Line 2242: l_job_start_date per_jobs.date_from%type;

2238: select date_from
2239: from per_jobs
2240: where job_id = c_job_id;
2241:
2242: l_job_start_date per_jobs.date_from%type;
2243: ---------------------------------------------------------------
2244: -- END OF BEN_ELIG_JOB_PRTE_F ----------------------
2245: ---------------------------------------------------------------
2246: ---------------------------------------------------------------

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: