APPS.MRP_SELECT_ALL_FOR_RELEASE_PUB dependencies on MTL_PARAMETERS

Line 822: (select organization_id from mtl_parameters mp

818: and implement_project_id IS NULL
819: and order_type <>2
820: and mr.project_id is NOT NULL
821: and organization_id IN
822: (select organization_id from mtl_parameters mp
823: where mp.project_control_level = 1
824: and mp.project_reference_enabled = 1
825: and mp.organization_id = mr.organization_id);
826:

Line 840: (select organization_id from mtl_parameters mp

836: and order_type <>2
837: and mr.project_id is NOT NULL
838: and mr.task_id is NOT NULL
839: and organization_id IN
840: (select organization_id from mtl_parameters mp
841: where mp.project_control_level = 2
842: and mp.project_reference_enabled = 1
843: and mp.organization_id = mr.organization_id);
844:

Line 1214: FROM mtl_parameters

1210: SELECT calendar_code,
1211: calendar_exception_set_id
1212: INTO arg_calendar_code,
1213: arg_exception_set_id
1214: FROM mtl_parameters
1215: WHERE organization_id = arg_org_id;
1216:
1217: IF SQL%NOTFOUND THEN
1218: raise_application_error(-200000, 'Cannot select calendar defaults');

Line 1431: from mtl_parameters

1427: V_RET1 NUMBER;
1428: begin
1429: select primary_cost_method
1430: into V_COST_METHOD
1431: from mtl_parameters
1432: where
1433: organization_id = X_ORG_ID;
1434: if( V_COST_METHOD = 1 ) then
1435: -- Standard Costing Organization

Line 1605: from mtl_parameters mp

1601: v_project_reference_enabled number;
1602: BEGIN
1603: select PRIMARY_COST_METHOD, PROJECT_REFERENCE_ENABLED
1604: into v_primary_cost_method, v_project_reference_enabled
1605: from mtl_parameters mp
1606: where
1607: mp.organization_id = X_ORG_ID;
1608:
1609: if v_primary_cost_method = 2 and v_project_reference_enabled = 1 then