DBA Data[Home] [Help]

APPS.PAY_FR_DB_PAY_SETUP dependencies on PER_JOBS_VL

Line 1233: from per_jobs_vl jb

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