23450: WHERE prl.wip_entity_id = wdj.wip_entity_id
23451: AND wdj.status_type IN (3,4,6)
23452: UNION ALL --Bug 16767247
23453: SELECT 'JOB IS VALID'
23454: FROM wip_repetitive_schedules wdj
23455: WHERE prl.wip_entity_id = wdj.wip_entity_id
23456: AND wdj.status_type IN (3,4,6));
23457:
23458: ELSIF p_document_type = g_document_type_RELEASE THEN
23508: WHERE pd.wip_entity_id = wdj.wip_entity_id
23509: AND wdj.status_type IN (3,4,6)
23510: UNION ALL --Bug 16767247
23511: SELECT 'JOB IS VALID'
23512: FROM wip_repetitive_schedules wdj
23513: WHERE pd.wip_entity_id = wdj.wip_entity_id
23514: AND wdj.status_type IN (3,4,6));
23515:
23516: ELSE--Other than document type RELEASE,REQUISITION
23568: WHERE pd.wip_entity_id = wdj.wip_entity_id
23569: AND wdj.status_type IN (3,4,6)
23570: UNION ALL --Bug 16767247
23571: SELECT 'JOB IS VALID'
23572: FROM wip_repetitive_schedules wdj
23573: WHERE pd.wip_entity_id = wdj.wip_entity_id
23574: AND wdj.status_type IN (3,4,6));
23575:
23576: END IF;