APPS.PO_PDOI_LINE_PROCESS_PVT dependencies on PER_JOBS_VL

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