DBA Data[Home] [Help]

APPS.PO_COPYDOC_SUB dependencies on PO_JOB_ASSOCIATIONS

Line 2380: FROM po_job_associations pja,

2376: l_progress := '040';
2377:
2378: SELECT mtl.concatenated_segments
2379: INTO l_category
2380: FROM po_job_associations pja,
2381: mtl_categories_kfv mtl
2382: WHERE pja.category_id = mtl.category_id
2383: AND pja.job_id = p_job_id;
2384:

Line 2387: FROM po_job_associations

2383: AND pja.job_id = p_job_id;
2384:
2385: SELECT 'Y'
2386: INTO l_valid_flag
2387: FROM po_job_associations
2388: WHERE job_id = p_job_id
2389: AND ( inactive_date is null
2390: OR trunc(sysdate) < trunc(inactive_date));
2391: