DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_TXNS_API dependencies on PER_JOBS

Line 1388: from per_jobs job

1384: --
1385: cursor c_JobIdLovVO(p_source_name1 varchar2, cv_effective_date date) is
1386: select jobtl.name name ,
1387: job.job_id id
1388: from per_jobs job
1389: ,per_jobs_tl jobtl
1390: where trunc(cv_effective_date)
1391: between Date_from and nvl(Date_to, trunc(cv_effective_date))
1392: and job.business_group_id + 0 = p_target_business_group_id

Line 1389: ,per_jobs_tl jobtl

1385: cursor c_JobIdLovVO(p_source_name1 varchar2, cv_effective_date date) is
1386: select jobtl.name name ,
1387: job.job_id id
1388: from per_jobs job
1389: ,per_jobs_tl jobtl
1390: where trunc(cv_effective_date)
1391: between Date_from and nvl(Date_to, trunc(cv_effective_date))
1392: and job.business_group_id + 0 = p_target_business_group_id
1393: and job.job_id = jobtl.job_id