DBA Data[Home] [Help]

APPS.PAY_DB_PAY_SETUP dependencies on PER_JOBS_VL

Line 1235: from per_jobs_vl jb

1231: if p_job_name is not NULL then
1232: --
1233: select jb.job_id
1234: into v_job_id
1235: from per_jobs_vl jb
1236: where upper(jb.name) = upper(p_job_name)
1237: and jb.business_group_id = v_business_group_id
1238: and v_effective_start_date between jb.date_from
1239: and nvl(jb.date_to,v_end_of_time);