APPS.INV_MIGRATE_PROCESS_ORG dependencies on DUAL

Line 39: FROM dual

35: X_failure_count OUT NOCOPY NUMBER) IS
36:
37: CURSOR Cur_check_subinventory IS
38: SELECT 1
39: FROM dual
40: WHERE EXISTS (SELECT 1
41: FROM mtl_secondary_inventories
42: WHERE secondary_inventory_name = P_whse_code
43: AND organization_id = P_organization_id);

Line 455: FROM dual

451:
452: /* Bug 5529682 - Changed reference to mtl_item_locations_kfv to mtl_item_locations */
453: CURSOR Cur_check_location(V_location VARCHAR2) IS
454: SELECT 1
455: FROM dual
456: WHERE EXISTS (SELECT 1
457: FROM mtl_item_locations
458: WHERE segment1 = V_location
459: AND organization_id = p_organization_id);

Line 463: FROM dual;

459: AND organization_id = p_organization_id);
460:
461: CURSOR Cur_get_id IS
462: SELECT mtl_item_locations_s.nextval
463: FROM dual;
464:
465: --Local Variables
466: l_migration_id NUMBER;
467: l_organization_id NUMBER;

Line 790: FROM dual

786: WHERE orgn_code = V_orgn_code;
787:
788: CURSOR Cur_check_subinventory(V_whse_code VARCHAR2, V_organization_id NUMBER) IS
789: SELECT 1
790: FROM dual
791: WHERE EXISTS (SELECT 1
792: FROM mtl_secondary_inventories
793: WHERE secondary_inventory_name = V_whse_code
794: AND organization_id = V_organization_id);

Line 1113: FROM dual;

1109: AND ( HOI2.ORG_INFORMATION_CONTEXT || '') ='Accounting Information';
1110:
1111: CURSOR Cur_get_unit IS
1112: SELECT hr_organization_units_s.nextval
1113: FROM dual;
1114:
1115: CURSOR Cur_org_code (v_org_code VARCHAR2, v_start_ch NUMBER) IS
1116: (SELECT substrb(v_org_code,1,v_start_ch)|| substrb(ltrim(to_char(to_number(rownum)-1,'099')), v_start_ch+1)
1117: FROM gl_sevt_ttl t1, gl_sevt_ttl t2