DBA Data[Home] [Help]

APPS.PO_PDOI_LINE_PROCESS_PVT dependencies on PER_JOBS_TL

Line 4166: per_jobs_tl jobs_tl

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'))

Line 4211: per_jobs_tl jobs_tl

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

Line 4235: per_jobs_tl jobs_tl,

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