DBA Data[Home] [Help]

APPS.PO_PDOI_LINE_PROCESS_PVT dependencies on PER_JOBS_TL

Line 5088: per_jobs_tl jobs_tl

5084: SELECT p_key,
5085: p_index_tbl(i),
5086: jobs_b.job_id
5087: FROM per_jobs jobs_b,
5088: per_jobs_tl jobs_tl
5089: WHERE p_job_name_tbl(i) IS NOT NULL
5090: AND x_job_id_tbl(i) IS NULL
5091: AND jobs_b.job_id = jobs_tl.job_id
5092: AND jobs_tl.language = NVL(p_file_line_language_tbl(i), userenv('LANG'))

Line 5133: per_jobs_tl jobs_tl

5129: SELECT p_key,
5130: p_index_tbl(i),
5131: jobs_b.job_id
5132: FROM per_jobs jobs_b,
5133: per_jobs_tl jobs_tl
5134: WHERE p_job_name_tbl(i) IS NOT NULL
5135: AND x_job_id_tbl(i) IS NULL
5136: AND x_job_business_group_id_tbl(i) IS NULL
5137: AND jobs_b.job_id = jobs_tl.job_id

Line 5157: per_jobs_tl jobs_tl,

5153: SELECT p_key,
5154: p_index_tbl(i),
5155: jobs_b.job_id
5156: FROM per_jobs jobs_b,
5157: per_jobs_tl jobs_tl,
5158: per_business_groups_perf groups
5159: WHERE p_job_name_tbl(i) IS NOT NULL
5160: AND x_job_id_tbl(i) IS NULL
5161: AND x_job_business_group_id_tbl(i) IS NOT NULL