APPS.CSTPECEP dependencies on WIP_ENTITIES

Line 204: FROM wip_entities we

200: AND WDJ.status_type IN (1,3,4,6,17)
201: AND p_job_option = 1
202: AND p_entity_type IN (1,6)
203: AND EXISTS ( SELECT 'X'
204: FROM wip_entities we
205: WHERE we.wip_entity_id = wdj.wip_entity_id
206: AND we.entity_type = p_entity_type
207: )RETURNING wdj.wip_entity_id BULK COLLECT INTO l_entity_id_tab;
208:

Line 239: FROM wip_entities WE

235: AND p_job_option = 3
236: AND WDJ.primary_item_id = p_inventory_item_id
237: AND p_entity_type = 1
238: AND EXISTS ( SELECT 'X'
239: FROM wip_entities WE
240: WHERE WE.wip_entity_id = WDJ.wip_entity_id
241: AND WE.entity_type = p_entity_type
242: )
243: RETURNING wdj.wip_entity_id BULK COLLECT INTO l_entity_id_tab;