APPS.WSH_WF_INTERFACE dependencies on MTL_PARAMETERS

Line 1350: FROM MTL_PARAMETERS

1346: WHERE organization_id = p_org_id;
1347:
1348: CURSOR get_org_code(p_org_id IN NUMBER) IS
1349: SELECT organization_code
1350: FROM MTL_PARAMETERS
1351: WHERE organization_id = p_org_id;
1352:
1353: l_gl_enable_sc_flag VARCHAR2(1);
1354: l_sp_enable_sc_flag VARCHAR2(1);

Line 1490: mtl_parameters mp,

1486:
1487: CURSOR get_manifest_status(l_delivery_id NUMBER) IS
1488: SELECT count(wnd.delivery_id)
1489: FROM wsh_new_deliveries wnd,
1490: mtl_parameters mp,
1491: wsh_carriers wc
1492: WHERE wnd.organization_id = mp.organization_id
1493: AND wnd.carrier_id = wc.carrier_id
1494: AND wc.manifesting_enabled_flag = 'Y'