4162: SELECT p_key,
4163: p_index_tbl(i),
4164: jobs_b.job_id
4165: FROM per_jobs jobs_b,
4166: per_jobs_tl jobs_tl
4167: WHERE p_job_name_tbl(i) IS NOT NULL
4168: AND x_job_id_tbl(i) IS NULL
4169: AND jobs_b.job_id = jobs_tl.job_id
4170: AND jobs_tl.language = NVL(p_file_line_language_tbl(i), userenv('LANG'))
4207: SELECT p_key,
4208: p_index_tbl(i),
4209: jobs_b.job_id
4210: FROM per_jobs jobs_b,
4211: per_jobs_tl jobs_tl
4212: WHERE p_job_name_tbl(i) IS NOT NULL
4213: AND x_job_id_tbl(i) IS NULL
4214: AND x_job_business_group_id_tbl(i) IS NULL
4215: AND jobs_b.job_id = jobs_tl.job_id
4231: SELECT p_key,
4232: p_index_tbl(i),
4233: jobs_b.job_id
4234: FROM per_jobs jobs_b,
4235: per_jobs_tl jobs_tl,
4236: per_business_groups_perf groups
4237: WHERE p_job_name_tbl(i) IS NOT NULL
4238: AND x_job_id_tbl(i) IS NULL
4239: AND x_job_business_group_id_tbl(i) IS NOT NULL