DBA Data[Home] [Help]

APPS.WMS_ZONES_PVT dependencies on MTL_PARAMETERS

Line 2280: FROM mtl_parameters

2276: WHERE zone_id = p_zone_id;
2277:
2278: CURSOR c_org_id IS
2279: SELECT 1
2280: FROM mtl_parameters
2281: WHERE organization_id = p_organization_id;
2282:
2283: CURSOR c_zone_name IS
2284: SELECT 1

Line 2581: FROM mtl_parameters

2577: l_id VARCHAR2(30);
2578:
2579: CURSOR c_org_id IS
2580: SELECT 1
2581: FROM mtl_parameters
2582: WHERE organization_id = p_organization_id;
2583:
2584: CURSOR c_zone_id IS
2585: SELECT 1

Line 2658: * p_organization_id must exist in MTL_PARAMETERS

2654:
2655: l_progress_indicator := '30';
2656:
2657: /**
2658: * p_organization_id must exist in MTL_PARAMETERS
2659: */
2660: OPEN c_org_id;
2661: FETCH c_org_id INTO l_id;
2662: IF c_org_id%NOTFOUND THEN