DBA Data[Home] [Help]

APPS.PO_COPYDOC_SUB dependencies on PO_JOB_ASSOCIATIONS

Line 2234: FROM po_job_associations pja,

2230: l_progress := '040';
2231:
2232: SELECT mtl.concatenated_segments
2233: INTO l_category
2234: FROM po_job_associations pja,
2235: mtl_categories_kfv mtl
2236: WHERE pja.category_id = mtl.category_id
2237: AND pja.job_id = p_job_id;
2238:

Line 2241: FROM po_job_associations

2237: AND pja.job_id = p_job_id;
2238:
2239: SELECT 'Y'
2240: INTO l_valid_flag
2241: FROM po_job_associations
2242: WHERE job_id = p_job_id
2243: AND ( inactive_date is null
2244: OR trunc(sysdate) < trunc(inactive_date));
2245: