APPS.GMD_SPEC_VRS_GRP dependencies on MTL_PARAMETERS

Line 106: FROM mtl_parameters m

102: -- Global Cursors
103:
104: CURSOR c_orgn ( p_organization_id NUMBER) IS
105: SELECT 1
106: FROM mtl_parameters m
107: WHERE m.process_enabled_flag = 'Y';
108:
109:
110: CURSOR c_status (p_status_code NUMBER) IS

Line 1589: mtl_parameters m,

1585: CURSOR c_orgn_plant ( p_organization_id IN NUMBER) IS
1586: SELECT 1
1587: FROM
1588: -- org_access_view o,
1589: mtl_parameters m,
1590: gmd_parameters_hdr h
1591: WHERE h.organization_id = m.organization_id
1592: AND m.process_enabled_flag = 'Y'
1593: AND m.organization_id = p_organization_id;

Line 4703: FROM mtl_parameters

4699: l_wms_enabled_flag VARCHAR2(1);
4700: BEGIN
4701: SELECT NVL(wms_enabled_flag,'N')
4702: INTO l_wms_enabled_flag
4703: FROM mtl_parameters
4704: WHERE organization_id = p_organization_id;
4705:
4706: IF l_wms_enabled_flag = 'Y' THEN
4707: RETURN TRUE;