APPS.PO_VAL_LINES2 dependencies on PO_JOB_ASSOCIATIONS_B

Line 644: FROM po_job_associations_b pja, per_jobs_vl pj

640: WHERE p_purchase_basis_tbl(i) = 'TEMP LABOR'
641: AND p_category_id_tbl(i) IS NOT NULL
642: AND NOT EXISTS(
643: SELECT 1
644: FROM po_job_associations_b pja, per_jobs_vl pj
645: WHERE pja.job_id = p_job_id_tbl(i)
646: AND pja.category_id = p_category_id_tbl(i)
647: AND pja.job_id = pj.job_id
648: AND NVL(TRUNC(pja.inactive_date), TRUNC(sysdate)) >= TRUNC(sysdate)