DBA Data[Home] [Help]

APPS.PAY_DB_PAY_SETUP dependencies on PER_JOBS_VL

Line 1258: from per_jobs_vl jb

1254: if p_job_name is not NULL then
1255: --
1256: select jb.job_id
1257: into v_job_id
1258: from per_jobs_vl jb
1259: where upper(jb.name) = upper(p_job_name)
1260: and jb.business_group_id = v_business_group_id
1261: and v_effective_start_date between jb.date_from
1262: and nvl(jb.date_to,v_end_of_time);