APPS.EAM_RES_USAGE_VALIDATE_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 60

    select 1
      into g_dummy
      from wip_operations wo
     where wo.organization_id = p_eam_res_usage_rec.organization_id
       and wo.wip_entity_id = p_eam_res_usage_rec.wip_entity_id
       and wo.operation_seq_num = p_eam_res_usage_rec.operation_seq_num;

Line: 101

    select 1
      into g_dummy
      from wip_operation_resources wor
     where wor.organization_id = p_eam_res_usage_rec.organization_id
       and wor.wip_entity_id = p_eam_res_usage_rec.wip_entity_id
       and wor.operation_seq_num = p_eam_res_usage_rec.operation_seq_num
       and wor.resource_seq_num = p_eam_res_usage_rec.resource_seq_num;

Line: 142

      select count(*)
        into g_dummy
        from bom_resource_equipments
       where instance_id = p_eam_res_usage_rec.instance_id
         and organization_id = p_eam_res_usage_rec.organization_id;

Line: 184

      select count(*)
        into g_dummy
        from mtl_serial_numbers msn, bom_resource_equipments bre
       where msn.inventory_item_id = bre.inventory_item_id
         and msn.current_organization_id = bre.organization_id
         and bre.instance_id = p_eam_res_usage_rec.instance_id
         and msn.serial_number = p_eam_res_usage_rec.serial_number;