APPS.PER_RI_WORKBENCH_PKG dependencies on HR_PUMP_BATCH_LINE_USER_KEYS

Line 370: (Select 1 From hr_pump_batch_line_user_keys uk where uk.user_key_value = 'RI~JOB_GROUP_NAME~'||pjg.internal_name)

366: Cursor csr_job_group_id Is
367: Select pjg.internal_name , pjg.job_group_id
368: From per_job_groups pjg
369: Where not exists
370: (Select 1 From hr_pump_batch_line_user_keys uk where uk.user_key_value = 'RI~JOB_GROUP_NAME~'||pjg.internal_name)
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

Line 377: (Select 1 From hr_pump_batch_line_user_keys uk where uk.user_key_value = 'RI~BENCHMARK_JOB_NAME~'||pj.name)

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';
380:
381: Begin