APPS.PO_PDOI_LINE_PROCESS_PVT dependencies on PER_JOBS_VL

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