DBA Data[Home] [Help]

APPS.PER_RI_WORKBENCH_PKG dependencies on PER_JOBS

Line 375: From per_jobs pj

371: and (pjg.business_group_id Is Null or pjg.business_group_id = p_business_group_id );
372:
373: Cursor csr_benchmark_job_id Is
374: Select pj.name, pj.job_id
375: From per_jobs pj
376: where not exists
377: (Select 1 From hr_pump_batch_line_user_keys uk where uk.user_key_value = 'RI~BENCHMARK_JOB_NAME~'||pj.name)
378: and pj.business_group_id = p_business_group_id
379: and pj.benchmark_job_flag='Y';