APPS.PO_PDOI_LINE_PROCESS_PVT dependencies on PER_JOBS

Line 4165: FROM per_jobs jobs_b,

4161: INSERT INTO po_session_gt(key, num1, num2)
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

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 4187: from per_jobs_vl

4183: /* -- START OF info added for debugging purpose
4184:
4185: select job_id, name, business_group_id
4186: bulk collect into d_job_id_tbl, d_job_name_tbl, d_bg_id_tbl
4187: from per_jobs_vl
4188: where TRUNC(sysdate) BETWEEN TRUNC(NVL(date_from, sysdate))
4189: AND TRUNC(NVL(date_to, sysdate));
4190:
4191: IF (PO_LOG.d_stmt) THEN

Line 4210: FROM per_jobs jobs_b,

4206: INSERT INTO po_session_gt(key, num1, num2)
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

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 4234: FROM per_jobs jobs_b,

4230: INSERT INTO po_session_gt(key, num1, num2)
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

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

Line 5390: per_jobs_vl job

5386: p_index_tbl(i),
5387: association.job_description,
5388: association.category_id
5389: FROM po_job_associations association,
5390: per_jobs_vl job
5391: WHERE job.job_id = p_job_id_tbl(i)
5392: AND association.job_id = job.job_id
5393: AND TRUNC(sysdate) < TRUNC(NVL(association.inactive_date, sysdate+1))
5394: AND TRUNC(sysdate) BETWEEN TRUNC(NVL(job.date_from, sysdate))

Line 7291: FROM per_jobs_vl

7287: AND draft_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
7288: AND draft_lines.draft_id = x_lines.draft_id_tbl(i)
7289: AND NVL(draft_lines.expiration_date, TRUNC(sysdate)) >= TRUNC(sysdate)
7290: AND EXISTS (SELECT 1
7291: FROM per_jobs_vl
7292: WHERE name = x_lines.job_name_tbl(i)
7293: AND job_id = draft_lines.job_id)
7294: AND NVL(draft_lines.expiration_date, TRUNC(sysdate)) >= TRUNC(sysdate);
7295:

Line 7322: FROM per_jobs_vl

7318: FROM po_lines_draft_all draft_lines
7319: WHERE draft_lines.po_line_id = txn_lines.po_line_id
7320: AND draft_lines.draft_id = x_lines.draft_id_tbl(i))
7321: AND EXISTS (SELECT 1
7322: FROM per_jobs_vl
7323: WHERE name = x_lines.job_name_tbl(i)
7324: AND job_id = txn_lines.job_id)
7325: AND NVL(txn_lines.expiration_date, TRUNC(sysdate)) >= TRUNC(sysdate)
7326: AND NVL(txn_lines.closed_code, 'OPEN') <> 'FINALLY CLOSED'