APPS.EAM_DIRECT_ITEMS_VALIDATE_PVT dependencies on WIP_OPERATIONS

Line 190: from wip_operations where

186: department_id = p_eam_direct_items_rec.department_id
187: and organization_id = p_eam_direct_items_rec.organization_id;
188:
189: select 1 into g_dummy
190: from wip_operations where
191: wip_entity_id = p_eam_direct_items_rec.wip_entity_id and
192: organization_id = p_eam_direct_items_rec.organization_id and
193: operation_seq_num = p_eam_direct_items_rec.operation_seq_num and
194: department_id = p_eam_direct_items_rec.department_id;

Line 342: and not exists (select 1 from wip_operations

338: select 1
339: into g_dummy
340: from dual
341: where p_eam_direct_items_rec.operation_seq_num = 1
342: and not exists (select 1 from wip_operations
343: where wip_entity_id = p_eam_direct_items_rec.wip_entity_id
344: and organization_id = p_eam_direct_items_rec.organization_id);
345: else
346: select 1

Line 348: from wip_operations wo

344: and organization_id = p_eam_direct_items_rec.organization_id);
345: else
346: select 1
347: into g_dummy
348: from wip_operations wo
349: where wo.organization_id = p_eam_direct_items_rec.organization_id
350: and wo.wip_entity_id = p_eam_direct_items_rec.wip_entity_id
351: and wo.operation_seq_num = p_eam_direct_items_rec.operation_seq_num;
352: end if;