APPS.EAM_ASSET_MOVE_UTIL dependencies on DUAL

Line 285: SELECT 'N' INTO l_flag FROM dual;

281: and organization_id = p_organization_id;
282:
283: EXCEPTION
284: WHEN NO_DATA_FOUND THEN
285: SELECT 'N' INTO l_flag FROM dual;
286: END;
287:
288: if (l_flag <> 'N') then
289: RETURN TRUE;

Line 448: SELECT 0 INTO l_intransitFlag FROM dual;

444: AND cii.SERIAL_NUMBER = msn.SERIAL_NUMBER ;
445: -- AND cii.INV_ORGANIZATION_ID = msn.CURRENT_ORGANIZATION_ID ;
446: EXCEPTION
447: WHEN NO_DATA_FOUND THEN
448: SELECT 0 INTO l_intransitFlag FROM dual;
449: END;
450:
451:
452: if(l_intransitFlag =5) then

Line 498: SELECT 'N' INTO l_network_asset_flag FROM dual;

494: WHERE instance_id = p_instance_id;
495:
496: EXCEPTION
497: WHEN NO_DATA_FOUND THEN
498: SELECT 'N' INTO l_network_asset_flag FROM dual;
499: END;
500:
501:
502: if (l_network_asset_flag ='Y') then

Line 764: SELECT 'N' INTO l_org_assign_chk FROM dual;

760: AND organization_id= p_organization_id;
761:
762: EXCEPTION
763: WHEN NO_DATA_FOUND THEN
764: SELECT 'N' INTO l_org_assign_chk FROM dual;
765: END;
766:
767:
768: