APPS.PO_VAL_LINES2 dependencies on PO_JOB_ASSOCIATIONS_B

Line 653: FROM po_job_associations_b pja, per_jobs_vl pj

649: WHERE p_purchase_basis_tbl(i) = 'TEMP LABOR'
650: AND p_category_id_tbl(i) IS NOT NULL
651: AND NOT EXISTS(
652: SELECT 1
653: FROM po_job_associations_b pja, per_jobs_vl pj
654: WHERE pja.job_id = p_job_id_tbl(i)
655: AND pja.category_id = p_category_id_tbl(i)
656: AND pja.job_id = pj.job_id
657: AND NVL(TRUNC(pja.inactive_date), TRUNC(sysdate)) >= TRUNC(sysdate)