APPS.PO_PDOI_LINE_PROCESS_PVT dependencies on PER_JOBS

Line 5087: FROM per_jobs jobs_b,

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

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

5105: /* -- START OF info added for debugging purpose
5106:
5107: select job_id, name, business_group_id
5108: bulk collect into d_job_id_tbl, d_job_name_tbl, d_bg_id_tbl
5109: from per_jobs_vl
5110: where TRUNC(sysdate) BETWEEN TRUNC(NVL(date_from, sysdate))
5111: AND TRUNC(NVL(date_to, sysdate));
5112:
5113: IF (PO_LOG.d_stmt) THEN

Line 5132: FROM per_jobs jobs_b,

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

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

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

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

Line 6312: per_jobs_vl job

6308: p_index_tbl(i),
6309: association.job_description,
6310: association.category_id
6311: FROM po_job_associations association,
6312: per_jobs_vl job
6313: WHERE job.job_id = p_job_id_tbl(i)
6314: AND association.job_id = job.job_id
6315: AND TRUNC(sysdate) < TRUNC(NVL(association.inactive_date, sysdate+1))
6316: AND TRUNC(sysdate) BETWEEN TRUNC(NVL(job.date_from, sysdate))

Line 8258: FROM per_jobs_vl

8254: AND draft_lines.po_header_id = x_lines.hd_po_header_id_tbl(i)
8255: AND draft_lines.draft_id = x_lines.draft_id_tbl(i)
8256: AND NVL(draft_lines.expiration_date, TRUNC(sysdate)) >= TRUNC(sysdate)
8257: AND EXISTS (SELECT 1
8258: FROM per_jobs_vl
8259: WHERE name = x_lines.job_name_tbl(i)
8260: AND job_id = draft_lines.job_id)
8261: AND NVL(draft_lines.expiration_date, TRUNC(sysdate)) >= TRUNC(sysdate);
8262:

Line 8289: FROM per_jobs_vl

8285: FROM po_lines_draft_all draft_lines
8286: WHERE draft_lines.po_line_id = txn_lines.po_line_id
8287: AND draft_lines.draft_id = x_lines.draft_id_tbl(i))
8288: AND EXISTS (SELECT 1
8289: FROM per_jobs_vl
8290: WHERE name = x_lines.job_name_tbl(i)
8291: AND job_id = txn_lines.job_id)
8292: AND NVL(txn_lines.expiration_date, TRUNC(sysdate)) >= TRUNC(sysdate)
8293: AND NVL(txn_lines.closed_code, 'OPEN') <> 'FINALLY CLOSED'