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 344: and not exists (select 1 from wip_operations

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

Line 350: from wip_operations wo

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