[Home] [Help]
364: ) Is
365:
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: